From what I understand, I need to execute the pg_dump command from the new server( so that it will use the 7.4.6 version), but connect to the old DB. Am I right?

Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Mon, Dec 20, 2004 at 06:40:34 -0800,
sarlav kumar <[EMAIL PROTECTED]>wrote:
> I would like to do a pg_dump on the test database, and restore it in the new database on Postgres 7.4.6. I would like to know if there would be any problem due to the postgres version/OS change. If so, could someone tell me what precautions I can take to avoid any problems?

You should use the 7.4.6 version of pg_dump to dump the old database. Note
you still need to be running the 7.3.2 server for the old database.
pg_dump will be just acting like a client connecting over the network
and will work with older versions of the server.

Do you Yahoo!?
Jazz up your holiday email with celebrity designs. Learn more.

Reply via email to