Thread: pg_dump on remote machine
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
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