From: | Zaid Shabbir <zaidshabbir(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Brock Henry <brock(dot)henry(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server |
Date: | 2024-07-29 03:12:42 |
Message-ID: | CABCJe_XwRwRpBdMs4XPZaVoKh3Bsq2SRtoheZ_X=LhH=zYX0sA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
One relevant question..
Is there any way to Stream pg_dumpall directly from single CentOS7 to
Multiple RHEL server directly through a single command ?
On Mon, Jul 29, 2024 at 7:12 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Brock Henry <brock(dot)henry(at)gmail(dot)com> writes:
> > I personally would create an ssh tunnel for port 5432, if ssh was open
> but
> > 5432 was not.
>
> +1, but I think your example is not quite right:
>
> > ssh -L 5432:localhost:5432 redhat_ip_address
> > pg_dumpall -U postgres | psql -h localhost -U postgres
>
> If you have a local PG server, it's probably using 5432 so that ssh
> can't bind to that. I think you want something like
>
> ssh -L 5433:localhost:5432 redhat_ip_address
> pg_dumpall -U postgres | psql -h localhost -p 5433 -U postgres
>
> where "5433" can be any locally-unused port number (caution: untested;
> the ssh arguments may still not be quite right).
>
> regards, tom lane
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-07-29 03:34:04 | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server |
Previous Message | Brock Henry | 2024-07-29 02:43:08 | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server |