PostgreSQL

Connecting to PostgreSQL

Enclave PostgreSQL Databases require authentication and SSL to connect.

Connecting with SSL

Most PostgreSQL clients will attempt connection over SSL by default. If yours doesn’t, try appending ?ssl=true to your connection URL, or review your client’s documentation.

Extensions

Enclave supports two families of images for Postgres: default and contrib.

  • The default images have a minimal number of extensions installed, but do include PostGIS.
  • The alternative contrib images have a larger number of useful extensions installed. The list of available extensions is visible in the repository we use to manage those images: aptible/docker-postgresql.

If you require a particular PostgreSQL plugin, contact Aptible Support to identify whether a contrib image is a good fit. Alternatively, you can launch a new PostgreSQL database using a contrib image with the aptible db:create command.

Replication

Master-slave replication is available for PostgreSQL. Contact Aptible Support to set up a follower.

Data Integrity and Durability

On Enclave, PostgreSQL is configured with default settings for write-ahead logging. Committed transactions are therefore guaranteed to be written to disk.

Connection Security

Enclave PostgreSQL Databases support connections via the following protocols:

  • For PostgreSQL versions 9.3, 9.4, 9.5, 9.6, and 10: TLSv1.0, TLSv1.1, TLSv1.2