Re: restore whoes - Mailing list pgsql-admin

From Tom Lane
Subject Re: restore whoes
Date
Msg-id 25253.1013387744@sss.pgh.pa.us
Whole thread Raw
In response to restore whoes  (Simone Tellini <tellini@areabusiness.it>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Jon August
Date:
Subject: Re: user to database restriction?
Next
From: Jon August
Date:
Subject: Re: user to database restriction?