Re: Stream pg_dumpall directly from CentOS7 to Red Hat server

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Sun, Jul 28, 2024 at 3:39 AM Wasim Devale <wasimd60@xxxxxxxxx> wrote:

Hi 

Can I use below command directly stream pg_dumpall from CentOS7 to RedHat 9:

pg_dumpall -U postgres | ssh postgres@redhat_ip_address "psql -U postgres"

That should work, if you can't get port 5432 open.

Nothing like testing, though, to make sure.