hipaa-postgres

---

A HIPAA & GDPR compliant ready Postgres Database image with PostGIS and PGAudit. Designed for parse-hipaa but can be used anywhere Postgres is used. These docker images include the necessary database auditing and logging for HIPAA compliance. hipaa-postgres is derived from postgis which is an extention built on top of the official postgres image.

hipaa-postgres provides the following:

• Auditing & logging
• Ready for encryption in transit - run behind a proxy with files & directions on how to complete the process with Nginx and LetsEncrypt

You will still need to setup the following on your own to be fully HIPAA compliant:

• Encryption in transit - you will need to complete the process
• Encryption at rest - Mount to your own encrypted storage drive (Linux and macOS have API's for this) and store the drive in a "safe" location
• Be sure to do anything else HIPAA requires

The CareKitSample-ParseCareKit app uses this image alongise parse-hipaa and ParseCareKit. If you are looking for a Mongo variant, checkout hipaa-mongo.

Use at your own risk. There is not promise that this is HIPAA compliant and we are not responsible for any mishandling of your data

Images

Multiple images are automatically built for your convenience. Images can be found at the following locations:

• Docker - Hosted on Docker Hub
• Singularity - Hosted on GitHub Container Registry

Tags

• latest - Points to the newest released version that uses the standard Postgres image
• main - Points to most up-to-date code that uses the standard Postgres image and will eventually show up in a future release. This tag can contain breaking changes
• x-x.x - Points to a specific Postgres and Postgis version that uses the standard Postgres image
• x-x.x-pgpool - Points to a specific Postgres and Postgis version that uses the standard Postgres image. These images alson contain pgpool and can be configured for High Availability
• x-x.x-percona - Points to a specific version that uses the Percona Distribtution for PostgreSQL image

Additional Packages inside of hipaa-postgres that are enabled automatically

The following are enabled automatically on either the PG_PARSE_DB or postgres databases:

• PostGIS - Spatial database extender for PostgreSQL object-relational database
• pgAudit - Provide the tools needed to produce audit logs required to pass certain government, financial, or ISO certification audits
• pgAudit-set_user - Allows switching users and optional privilege escalation with enhanced logging and control
• pgBadger - Log analyzer built for speed with fully detailed reports and professional rendering
• pgBackrest - Reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements
• pg_cron - Run periodic jobs in PostgreSQL
• pg_repack - Reorganize tables in PostgreSQL databases with minimal locks
• pgStatStatements - Provides a means for tracking planning and execution statistics of all SQL statements executed by a server (needed for PMM)
• Percona Monitoring and Management (PMM) - Monitor the health of your database infrastructure, explore new patterns in database behavior, and manage and improve the performance of your databases no matter where they are located or deployed

pgpool tagged images

Images that are tagged with -pgpool have additional packages to make it easier to configure hipaa-postgres to work with pgpool. The additional packages are below:

• pgpool - Manages a pool of PostgreSQL servers to achieve some features that are not available with single PostgreSQL installation. The features include: High Availability, Load balancing, Connection Pooling, Online Recovery, Limiting Exceeding Connections, Watchdog, In Memory Query Cache
• iputils-ping - A utility for Linux networking
• openssh-server - Connectivity tool for remote login with the SSH protocol
• supervisor - Client/server system that allows its users to monitor and control a number of processes on UNIX-like operating systems

Environment Variables

POSTGRES_PASSWORD # Password for postgress db cluster (Be sure to changes this in real deployments)
PG_PARSE_USER # Username for logging into PG_PARSE_DB (Be sure to changes this in real deployments)
PG_PARSE_PASSWORD # Password for logging into PG_PARSE_DB (Be sure to changes this in real deployments)
PG_PARSE_DB # Name of parse-hipaa database
PMM_USER=pmm # Username for Percona Monitor Managemet (Be sure to changes this in real deployments)
PMM_PASSWORD=pmm # Password for Percona Monitor Managemet (Be sure to changes this in real deployments)
PMM_PORT=80 # This is the default port on the docker image
PMM_TLS_PORT=443 # This is the default TLS port on the docker image

Starting up hipaa-postgres

To get started, the docker-compose.yml file provides an example of how to use hipaa-postgres, simply type:

docker-compose up

Imporant Note: On the very first run of hipaa-postgres needs time to setup and will not allow connections until it is ready. This is suppose to happen as time is needed to configure the necessary scripts/extensions along setup any default databases. hipaa-postgres will begin to allow connectoins once it finishes configuring and a message like below will show in the logs:

db_1 | PostgreSQL init process complete; ready for start up.

Afterwards, hipaa-postfgress will allow all connections.

Configuring

If you are plan on using hipaa-postgres in production. You should run the additional scripts to create the rest of the indexes for optimized queries.

The setup-parse-index.sh file is already in the container. You just have to run it.

1. Log into your docker container, type: docker exec -u postgres -ti parse-hipaa_db_1 bash
2. Run the script, type: /usr/local/bin/setup-parse-index.h

If you want to persist the data in the database, you can uncomment the volume lines in docker-compose.yml. Be sure to change the directory to secure place that docker has access to.

Default values for environment variable are provided in docker-compose.yml for quick local deployment. If you plan on using this image to deploy in production, you should definitely change all environment variable. Note that the postgres image provides a default user of postgres user to configure the database cluster, you can change the password for the postgres user by changing POSTGRES_PASSWORD before the first initialization. There are plenty of postgres environment variables that can be modified. Postgres environment variables should not be changed unless you are confident with configuring postgres or else you image may not work properly. Note that changes to the aforementioned parameters will only take effect if you change them before the first build and run of the image. Afterwards, you will need to make all changes by connecting to the image typing:

docker exec -u postgres -ti parse-hipaa_db_1 bash

You can then make modifications using psql. Through psql, you can also add multiple databases and users to support a number of parse apps.

Monitoring your database with Percona Monitoring and Management

hipaa-postgres is configured automatically to allow acces to PMM. If you are using the docker-compose.yml file, this can be accessed by visiting http://localhost:1080/. Additional information is below:

• Username/password - admin/admin, PMM will prompt you to change this on first login
• Adding your database to PMM
  1. Goto Settings->Add Instance to PMM->PostgreSQL
  2. Enter db for hostname
  3. For Username, enter PMM_USER configured in your environment variable
  4. For Password, enter PMM_PASSWORD configured in your environment variable
  5. Click Add service... It can take up to 5 minutes for data to start populating in PMM. PMM will let you know if it has trouble connecting immediatly after you perform the steps above. You can see that PMM is able to connect and read your database version correctly on the PostgreSQL section of the dashboard
  6. Learn more about PMM by looking through the documentation

Deploying on a real system

The docker yml's here are intended to run behind a proxy that properly has ssl configured to encrypt data in transit. To create a proxy to parse-hipaa, nginx files are provided here. Simply add the sites-available folder to your nginx directory and add the following to "http" in your nginx.conf:

http {
    include /usr/local/etc/nginx/sites-enabled/*.conf; #Add this line to end. This is for macOS, do whatever is appropriate on your system
}

Setup your free certificates using LetsEncrypt, follow the directions here. Be sure to change the certificate and key lines to point to correct location in default-ssl.conf.