pg_dump on remote machine

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

pg_dump on remote machine

От:
"Askar Zaidi" <askar@mail.nplindia.ernet.in>
Дата:
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 <kaminski@univention.de>
Дата:
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


FAQ