Re: pg_dump on remote machine - Mailing list pgsql-admin

From Thomas Kaminski
Subject Re: pg_dump on remote machine
Date
Msg-id 1113214659.9945.10.camel@anton.knut.univention.de
Whole thread Raw
In response to pg_dump on remote machine  ("Askar Zaidi" <askar@mail.nplindia.ernet.in>)
List 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 by date:

Previous
From: "Askar Zaidi"
Date:
Subject: pg_dump on remote machine
Next
From: Reuly Bússolo Mendes
Date:
Subject: Problem in order by