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 CANzqJaD1wg5MMM1fBeRxZfoXPcekPNh7fTF7sDzQgfBVSO-2FQ@mail.gmail.com
Whole thread Raw
In response to Stream pg_dumpall directly from CentOS7 to Red Hat server  (Wasim Devale <wasimd60@gmail.com>)
List pgsql-admin
Tree view
On Sun, Jul 28, 2024 at 3:39 AM Wasim Devale <wasimd60@gmail.com> 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. 

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Faster pg_resore with autovacuum off?
Next
From: Laurenz Albe
Date:
Subject: Re: Faster pg_resore with autovacuum off?