Re: pg_dump on remote machine

Поиск
Список
Период
Сортировка
От Thomas Kaminski
Тема Re: pg_dump on remote machine
Дата
Msg-id 1113214659.9945.10.camel@anton.knut.univention.de
обсуждение исходный текст
Ответ на pg_dump on remote machine  ("Askar Zaidi" <askar@mail.nplindia.ernet.in>)
Список pgsql-admin
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



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Askar Zaidi"
Дата:
Сообщение: pg_dump on remote machine
Следующее
От: Reuly Bússolo Mendes
Дата:
Сообщение: Problem in order by