agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Wasim Devale <wasimd60@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
Date: Sun, 28 Jul 2024 14:29:48 +0200
Message-ID: <d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at> (raw)
In-Reply-To: <CAB5fag4b0bhFx7UVP=45_LL_aNdt60v421p2bM0PTqPrP-3ALQ@mail.gmail.com>
References: <CAB5fag4b0bhFx7UVP=45_LL_aNdt60v421p2bM0PTqPrP-3ALQ@mail.gmail.com>

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@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

view thread (12+ messages)  latest in thread

Message-ID: <d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at>
Permalink:  ../d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at/
Also on:    postgresql.org/message-id/d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, wasimd60@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
  In-Reply-To: <d3077ef8746e982190144b050b59b06df0e96237.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox