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.klaver@xxxxxxxxxxx
