Re: Stream pg_dumpall directly from CentOS7 to Red Hat server

(Before I answer: *WHY?*)

Not intrinsically. You might be able to play weird games with ssh
tunneling, but then I'd say "find a different solution to your problem."

On Sun, Jul 28, 2024 at 11:13 PM Zaid Shabbir <zaidshabbir(at)gmail(dot)com> wrote:

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