Обсуждение: pg_dump on remote machine

Поиск
Список
Период
Сортировка

pg_dump on remote machine

От
"Askar Zaidi"
Дата:
I have been trying to dump my data from one machine to another. I have
proper configuration in the pg_hba.conf file on both machines. I can connect
to the remote DB using :

psql -h 172.16.1.39 ha

I then run the command:

pg_dump -h 172.16.1.20 evo10

to get the DB evo10 from machine 172.16.1.20

it displays me a few messgs saying that PostgreSql database dump complete.

Finally I check the machine on which dump was taken but the DB evo10 simply
does not exist. If the pg_dump is taking a dump without any warning or error
whatsoever..where is my DB dump???

Any clues??

Thanks

Askar Zaidi
Central Computer Facility,
National Physical Laboratory,
New Delhi, India

Re: pg_dump on remote machine

От
Thomas Kaminski
Дата:
Hello,

> I have been trying to dump my data from one machine to another. I have
> proper configuration in the pg_hba.conf file on both machines. I can connect
> to the remote DB using :
>
> psql -h 172.16.1.39 ha
>
> I then run the command:
>
> pg_dump -h 172.16.1.20 evo10
>
> to get the DB evo10 from machine 172.16.1.20
>
> it displays me a few messgs saying that PostgreSql database dump complete.
>
> Finally I check the machine on which dump was taken but the DB evo10 simply
> does not exist. If the pg_dump is taking a dump without any warning or error
> whatsoever..where is my DB dump???
>
> Any clues??


try
pg_dump -h 172.16.1.20 evo10 > dumpfile.sql


Bye Thomas