Bug #923: psql can't read file prepaired by pg_dumpall - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #923: psql can't read file prepaired by pg_dumpall
Date
Msg-id 20030328223649.28F7347580B@postgresql.org
Whole thread Raw
List pgsql-bugs
Krzysztof Czuma (czuma@poland.org) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
psql can't read file prepaired by pg_dumpall

Long Description
I can't move databases from PostgreSQL 7.0 to PostgreSQL 7.3

When I try to execute:

psql -d template1 -f zbior

I see:
---------------------------------------------------------------------
 You are now connected to database template1.
SELECT
DELETE 0
DROP TABLE
psql:zbior:5: ERROR:  copy: line 1, Bad abstime external representation 'xjtyscak'
psql:zbior:5: lost synchronization with server, resetting connection
DELETE 1
psql:zbior:32: \connect: FATAL:  user "user3" does not exist
---------------------------------------------------------------------

5th line in zbior:
copy pg_shadow from stdin;

6th line in zbior:
user1    124     f       f       f       f       xjtyscak        \N

11th line in zbior:

user2        132     f       f       f       f       hcveiahz        2038-01-18 00:00:00+01


Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Unable to delete rows...
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #924: Segmentation fault in libpq/PQconsumeInput on SSL connection