Hi Sarlav,

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?

Basically.

The truth is Sarlav, that any pg_dump version before the new 8.0 version is likely to have errors restoring. You should restore the dump like this:

psql -f dump.sql database

And then when you get errors, you will see the line number of the error. Then you can edit the dump to fix it.

Chris

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to