On Sun, Jul 28, 2024 at 8:30 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote: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 postgresThe correct way, if port 5432 is open. Which isn't always the case.
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
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных