| From: | Thomas Kaminski <kaminski(at)univention(dot)de> |
|---|---|
| To: | Askar Zaidi <askar(at)mail(dot)nplindia(dot)ernet(dot)in> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_dump on remote machine |
| Date: | 2005-04-11 10:17:39 |
| Message-ID: | 1113214659.9945.10.camel@anton.knut.univention.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reuly Bússolo Mendes | 2005-04-11 13:15:35 | Problem in order by |
| Previous Message | Askar Zaidi | 2005-04-11 09:34:21 | pg_dump on remote machine |