restore whoes - Mailing list pgsql-admin

Hi there,

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
DEBUG:  pq_flush: send() failed: Broken pipe
FATAL 1:  Socket command type
 unknown
ERROR:  Relation "tipi" does not exist
psql:backup.sql:96823: ERROR:  Relation "tipi" does not exist
psql:backup.sql:96830: invalid command \.
ERROR:  parser: parse error at or near "0"
psql:backup.sql:96838: ERROR:  parser: parse error at or near "0"
psql:backup.sql:96950: invalid command \N
psql:backup.sql:96950: invalid command \N
psql:backup.sql:96951: invalid command \N
psql:backup.sql:96951: invalid command \N
psql:backup.sql:96952: invalid command \N
psql:backup.sql:96952: invalid command \N
psql:backup.sql:96953: invalid command \N
psql:backup.sql:96953: invalid command \N
psql:backup.sql:96954: invalid command \N
psql:backup.sql:96954: invalid command \N
psql:backup.sql:96955: invalid command \N
psql:backup.sql:96955: invalid command \N
psql:backup.sql:96956: invalid command \N
psql:backup.sql:96956: invalid command \N
psql:backup.sql:96957: invalid command \N
psql:backup.sql:96957: invalid command \N
psql:backup.sql:97055: invalid command \.
ERROR:  parser: parse error at or near "9223"
psql:backup.sql:97062: ERROR:  parser: parse error at or near "9223"
ERROR:  Relation "prodotti" does not exist
psql:backup.sql:97070: ERROR:  Relation "prodotti" does not exist
ERROR:  Relation "tipi" does not exist
psql:backup.sql:97078: ERROR:  Relation "tipi" does not exist
ERROR:  Relation "particolari" does not exist
psql:backup.sql:97086: ERROR:  Relation "particolari" does not exist
You are now connected to database template1 as user wiznet.
CREATE DATABASE

Don't know what happened exactly, but it seems it failed when restoring
a lot of text entries. Line 94383+47 (if this is how "line 47" should be
interpreted) looks like "^M\" in vim, without quotes - I think it is a
CR character.

Anyway, it seems it skipped a lot of backup lines then, as it completely
failed to recover a database following the records of that table: you
can see the error lines when it tried to create the tables in that db,
without having created it. Obviously it also skipped the rest of the
dump of the previous db.

It seems I'll stick to 7.1.3 for a while on the production machine
(hoping I won't need to restore the db there too... I'm a bit scared now)

--

Simone Tellini
E-mail: tellini@areabusiness.it
http://www.areabusiness.it