Re: Stream pg_dumpall directly from CentOS7 to Red Hat server

[Laurenz Albe <laurenz.albe@xxxxxxxxxxx>]

On Sun, 2024-07-28 at 13:09 +0530, Wasim Devale wrote:
> 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"

No idea, but the correct way is

  pg_dumpall -U postgres | psql -h redhat_ip_address -U postgres

Yours,
Laurenz Albe