pg_dump

Started by Tom Allisonover 18 years ago2 messagesgeneral
Jump to latest
#1Tom Allison
tom@tacocat.net

just checking to be sure.

pg_dump does not support SSL connections?

I have been using pgsql with ssl connections to my database.
But when I tried pg_dump I was hit with the "no ssl" error message.
Didn't see an option for it in the RTFM so .. Am I correct in
assuming that pg_dump/pg_restore are not supposed to run via ssl?

#2Michael Fuhr
mike@fuhr.org
In reply to: Tom Allison (#1)
Re: pg_dump

On Mon, Jul 30, 2007 at 07:26:45PM -0400, Tom Allison wrote:

pg_dump does not support SSL connections?

pg_dump sits atop libpq, which can use SSL if PostgreSQL was built
with SSL support.

I have been using pgsql with ssl connections to my database.
But when I tried pg_dump I was hit with the "no ssl" error message.

What was the exact command and the exact error message?

Didn't see an option for it in the RTFM so .. Am I correct in
assuming that pg_dump/pg_restore are not supposed to run via ssl?

No, that's not correct; pg_dump can use SSL just as any other libpq
application can. Are you sure your pg_dump is linked against an
SSL-enabled libpq? Have you tried setting the PGSSLMODE environment
variable? What version of PostgreSQL are you running?

--
Michael Fuhr