Re: pg_dump to a remote server - Mailing list pgsql-general

From Ron
Subject Re: pg_dump to a remote server
Date
Msg-id c105053c-372c-b258-5a27-ca952e7f063b@gmail.com
Whole thread Raw
In response to Re: pg_dump to a remote server  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_dump to a remote server
RE: pg_dump to a remote server
List pgsql-general

On 04/16/2018 07:18 PM, Adrian Klaver wrote:
> On 04/16/2018 04:58 PM, Ron wrote:
>> We're upgrading from v8.4 to 9.6 on a new VM in a different DC.  The dump 
>> file will be more than 1TB, and there's not enough disk space on the 
>> current system for the dump file.
>>
>> Thus, how can I send the pg_dump file directly to the new server while 
>> the pg_dump command is running?  NFS is one method, but are there others 
>> (netcat, rsync)?  Since it's within the same company, encryption is not 
>> required.
>
> Maybe?:
>
> pg_dump -d test -U postgres -Fc | ssh aklaver@arkansas 'cat > test_cat.out'

That looks promising.  I could then "pg_restore -jX".

-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_dump to a remote server
Next
From: Keith Fiske
Date:
Subject: Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade