On 04/16/2018 11:07 PM, Adrian Klaver wrote:
On 04/16/2018 06:43 PM, Ron wrote:


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".

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?

--
Angular momentum makes the world go 'round.

Reply via email to