PostgreSQL SSL Off

Connecting to PostgreSQL fails with "no pg_hba.conf entry for host, ... SSL off"

Cause

This error means that your PostgreSQL client is configured to connect to without SSL, but PostgreSQL Databases on Aptible require SSL.

Resolution

Many PostgreSQL clients allow enforcing SSL by appending ?ssl=true to the default database connection URL provided by Aptible.

For some clients or libraries, it may be necessary to set this in configuration code.

If you have questions about enabling SSL for your app's PostgreSQL library, please contact Aptible Support.