Re: Stream pg_dumpall directly from CentOS7 to Red Hat server

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Wasim Devale <wasimd60(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, 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:29:48
Message-ID: d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-07-28 12:33:28 Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Previous Message Wasim Devale 2024-07-28 07:39:04 Stream pg_dumpall directly from CentOS7 to Red Hat server