On Sun, Jul 28, 2024 at 3:39 AM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
> 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"
>
That *should* work, if you can't get port 5432 open.
Nothing like testing, though, to make sure.