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])