Re: restore whoes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simone Tellini <tellini(at)areabusiness(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: restore whoes
Date: 2002-02-11 00:35:44
Message-ID: 25253.1013387744@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Simone Tellini <tellini(at)areabusiness(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-11 01:03:27 Re: user to database restriction?
Previous Message Jon August 2002-02-11 00:22:34 Re: user to database restriction?