Stream pg_dumpall directly from CentOS7 to Red Hat server

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Stream pg_dumpall directly from CentOS7 to Red Hat server
Date: 2024-07-28 07:39:04
Message-ID: CAB5fag4b0bhFx7UVP=45_LL_aNdt60v421p2bM0PTqPrP-3ALQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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"

Thanks,
Wasim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-28 12:29:48 Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Previous Message Wasim Devale 2024-07-28 05:52:38 Re: Restoration query