Hi all

I have a problem trying to restore a backup of a database from postgres 7.4
to 8. When I execute the backup file with "\i FILE" i get a lot of messages
of "invalid command \N" when try to restore the data of tables.

The tables are restored ok but the primary and foreign keys, and data table
aren't restored.

I use pg_dump for backup and \i FILE for restore.

which way are better for make backup and restore?

Best regards.

On Jan 26, 3:33 am, ismael <ismael.perna... (AT) gmail (DOT) es> wrote:
One way I have resolved this same issue in the past was to restore
'Database Schema only' first then restore 'Data only' afterwards. Hope
this helps.

Regards,

Enrique Martinez
Sr. Web/Database Developer

"EMartinez" <emartinez.pr1 (AT) gmail (DOT) com> schreef in bericht
news:1171515456.174520.300770 (AT) l53g2000cwa (DOT) googlegroups.com...
8.1.5 to 8.1.5 by using 'psql ... -f FILE' to restore.
Apperently \i cannot handle dumps with 'COPY table ( field ..., fieldn) FROM
stdin;'.
Dumps created with -d of -D option can be restored interactively.

HansH