Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
| От | Brock Henry |
|---|---|
| Тема | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server |
| Дата | |
| Msg-id | CAAFiYLGLjsvDuALdJmJXA6Yo0meGuHYob0zQa1KMvf2gJuhg+g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: Stream pg_dumpall directly from CentOS7 to Red Hat server
|
| Список | pgsql-admin |
I personally would create an ssh tunnel for port 5432, if ssh was open but 5432 was not.
ssh -L 5432:localhost:5432 redhat_ip_address
pg_dumpall -U postgres | psql -h localhost -U postgres
The two commands in separate windows/sessions.
On Sun, 28 Jul 2024 at 22:33, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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.
В списке pgsql-admin по дате отправления: