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:33:28
Message-ID: CANzqJaAO0AGKq3S946sM-7tsZpSi+S0uG_PcsRaAqzo+Zpo6gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Jul 28, 2024 at 8:30 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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(at)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-28 12:34:16 Re: Faster pg_resore with autovacuum off?
Previous Message Laurenz Albe 2024-07-28 12:29:48 Re: Stream pg_dumpall directly from CentOS7 to Red Hat server