Re: pg_dump to a remote server

On 04/17/2018 12:35 AM, Ron wrote:
> On 04/16/2018 11:07 PM, Adrian Klaver wrote:
>> On 04/16/2018 06:43 PM, Ron wrote:
>>>

>> More promising would be the suggestion from Michael Nolan:
>>
>> https://www.postgresql.org/message-id/CAOzAqu%2BVpOfzBHwcqptSzm3PkeZAjkqqc0XqB%2BA-jBNioU6x%2Bg%40mail.gmail.com
>>
>>
>> "Can you run pg_dump on the new server, connecting remotely to the
>> current one?"
>>
>> It eliminates two programs(ssh and cat) and a pipe.
>
> Is that supported?
>

Sure as long as pg_dump on the new server can reach -h and the
pg_hba.conf for the current server is set up to allow connections from
the remote client.

To test do something like:

new_server> pg_dump -t some_table -s -h current_server -f test_file.sql

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com