pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump from one server to another using SSL
2+ messages / 2 participants
[nested] [flat]
* pg_dump from one server to another using SSL
@ 2010-03-18 14:45 Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Campbell, Lance @ 2010-03-18 14:45 UTC (permalink / raw)
To: pgsql-admin
PostgreSQL 8.4.3
Assume you have two servers running PostgreSQL with SSL on.
How do you tell pg_dump to use SSL when loading data from one server
into another server?
Thanks,
Lance Campbell
Software Architect/DBA/Project Manager
Web Services at Public Affairs
217-333-0382
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dump from one server to another using SSL
@ 2010-03-18 15:22 Tom Lane <tgl@sss.pgh.pa.us>
parent: Campbell, Lance <lance@illinois.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-03-18 15:22 UTC (permalink / raw)
To: Campbell, Lance <lance@illinois.edu>; +Cc: pgsql-admin
"Campbell, Lance" <lance@illinois.edu> writes:
> How do you tell pg_dump to use SSL when loading data from one server
> into another server?
It will likely do so by default, but if you want to be sure you can do
export PGSSLMODE=require
before starting pg_dump. See
http://www.postgresql.org/docs/8.4/static/libpq-envars.html
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-03-18 15:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-18 14:45 pg_dump from one server to another using SSL Campbell, Lance <lance@illinois.edu>
2010-03-18 15:22 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox