Postgres Pro
Downloads
Home   >   mailing lists

Re: Stream pg_dumpall directly from CentOS7 to Red Hat server - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Date
Msg-id d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at
Whole thread Raw
In response to Stream pg_dumpall directly from CentOS7 to Red Hat server  (Wasim Devale <wasimd60@gmail.com>)
Responses Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Wasim Devale
Date:
Subject: Stream pg_dumpall directly from CentOS7 to Red Hat server
Next
From: Ron Johnson
Date:
Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server