Set sslmode=allow with pg_dump

postgresql ssl pg-dump
qwertzguy picture qwertzguy · Apr 24, 2017 · Viewed 8k times · Source

I need to specify sslmode=allow when using psql to connect to my PostgreSQL DB, like: psql sslmode=allow -h localhost -p 5432 otherwise I get server does not support SSL, but SSL was required

I tried specifying the same option to pg_dump but it doesn't recognize the option.

How do I specify sslmode to pg_dump?

Answer

qwertzguy picture qwertzguy · Apr 24, 2017

You need to use the environment variable PGSSLMODE like this:

PGSSLMODE=allow pg_dump -h localhost -p 5432

Related questions

Using psql to connect to PostgreSQL in SSL mode

I am trying to configure ssl certificate for PostgreSQL server. I have created a certificate file (server.crt) and key (server.key) in data directory and update the parameter SSL to "on" to enable secure connection. I just want only …

Read More
Postgres SSL SYSCALL error: EOF detected with python and psycopg

Using psycopg2 package with python 2.7 I keep getting the titled error: psycopg2.DatabaseError: SSL SYSCALL error: EOF detected It only occurs when I add a WHERE column LIKE ''%X%'' clause to my pgrouting query. An example: SELECT id1 …

Read More
How to connect to a remote PostgreSQL database through SSL with Python

I want to connect to a remote PostgreSQL database through Python to do some basic data analysis. This database requires SSL (verify-ca), along with three files (which I have): Server root certificate file Client certificate file Client key file I …

Read More