Aptible PostgreSQL Databases require authentication and SSL to connect.
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.
Most PostgreSQL clients will not attempt verification of the server certificate by default, please consult your client's documentation to enable
verify-full, or your client's equivalent option. The relevant documentation for libpq is here.
By default, PostgreSQL Databases on Aptible use a server certificate signed by Aptible for SSL / TLS termination. Databases that have been running since prior to Jan 15th, 2021 will only have a self-signed certificate. See Database Encryption in Transit for more details.
Aptible 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.
On Aptible, PostgreSQL is configured with default settings for write-ahead logging. Committed transactions are therefore guaranteed to be written to disk.
PostgreSQL databases on Aptible autotune the size of their caches and working memory based on the size of their container in order to improve performance. See the image's public git repo for details.
The following settings are autotuned:
Modifying these settings is not recommended as the setting will no longer scale with the size of the database's container.
Aptible PostgreSQL Databases support connections via the following protocols:
- For PostgreSQL versions 9.3, 9.4, 9.5, 9.6, 10, and 11:
Updated about 20 hours ago