Re: pg_dump from one server to another using SSL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump from one server to another using SSL
Date: 2010-03-18 15:22:50
Message-ID: 11249.1268925770@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Campbell, Lance" <lance(at)illinois(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Iñigo Martinez Lasala 2010-03-18 16:41:31 Missing tsearch2 functions
Previous Message Campbell, Lance 2010-03-18 14:45:06 pg_dump from one server to another using SSL