Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Date
Msg-id CANzqJaAO0AGKq3S946sM-7tsZpSi+S0uG_PcsRaAqzo+Zpo6gw@mail.gmail.com
Whole thread Raw
In response to Re: Stream pg_dumpall directly from CentOS7 to Red Hat server  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
List pgsql-admin
Tree view
On Sun, Jul 28, 2024 at 8:30 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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


The correct way, if port 5432 is open.  Which isn't always the case.

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Next
From: Laurenz Albe
Date:
Subject: Re: Faster pg_resore with autovacuum off?