Skip to main content

Troubleshoot `server does not support SSL` in PostgreSQL exports

Fix a PostgreSQL export that fails because SSL isn't enabled on the database server.

Problem summary

Your PostgreSQL export can't connect because SSL isn't turned on for your database server.

​

Error message or symptoms

The export fails with an error that contains:

​

server does not support SSL

​

or:

​

SSL is not enabled on the server

​

When does this occur

  • SSL is turned off on the PostgreSQL server that the export connects to.

​

Root cause

Funnel connects to PostgreSQL using SSL, which is one of the PostgreSQL export requirements.

​

When the server doesn't accept SSL connections, the connection fails.

​

Solution

  1. Turn on SSL on your PostgreSQL server. For a managed database, turn it on in your provider's settings. For a self-managed server, set ssl = on in postgresql.conf and add a certificate.

    ​

  2. Run the export again.

Did this answer your question?