Re: Stream pg_dumpall directly from CentOS7 to Red Hat server

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Date: 2024-07-28 12:35:35
Message-ID: CANzqJaD1wg5MMM1fBeRxZfoXPcekPNh7fTF7sDzQgfBVSO-2FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Jul 28, 2024 at 3:39 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:

> Hi
>
> Can I use below command directly stream pg_dumpall from CentOS7 to RedHat
> 9:
>
> pg_dumpall -U postgres | ssh postgres(at)redhat_ip_address "psql -U postgres"
>

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

Nothing like testing, though, to make sure.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-28 12:40:32 Re: Faster pg_resore with autovacuum off?
Previous Message Laurenz Albe 2024-07-28 12:34:16 Re: Faster pg_resore with autovacuum off?