pg_dump from one server to another using SSL

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAC6A9.999BB48A
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

PostgreSQL 8.4.3

=20

Assume you have two servers running PostgreSQL with SSL on. =20

=20

How do you tell pg_dump to use SSL when loading data from one server
into another server?=20

=20

Thanks,

=20

Lance Campbell

Software Architect/DBA/Project Manager

Web Services at Public Affairs

217-333-0382

=20


------_=_NextPart_001_01CAC6A9.999BB48A
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: pg_dump from one server to another using SSL

"Campbell, Lance" 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin