Simone Tellini <tellini@areabusiness.it> writes:
> I was trying to restore a dump from pg 7.1.3 to the newly installed 7.2,
> but I got these errors:
> You are now connected as new user postgres.
> ERROR: copy: line 47, CopyReadAttribute: end of record marker corrupted
> psql:backup.sql:94383: ERROR: copy: line 47, CopyReadAttribute: end of record marker corrupted
> psql:backup.sql:94383: lost synchronization with server, resetting connection
It's going to be difficult to do anything about this unless you show us
the failing data. The segment of the dump file right around line 94383
would be interesting, as would the declaration of the table that's being
loaded there. Also, what locale and/or multibyte settings are you using?
regards, tom lane