Обсуждение: pg_dump from one server to another using SSL

Поиск
Список
Период
Сортировка

pg_dump from one server to another using SSL

От
"Campbell, Lance"
Дата:

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

 

Re: pg_dump from one server to another using SSL

От
Tom Lane
Дата:
"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