Bug #923: psql can't read file prepaired by pg_dumpall

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #923: psql can't read file prepaired by pg_dumpall
Date: 2003-03-28 22:36:49
Message-ID: 20030328223649.28F7347580B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Krzysztof Czuma (czuma(at)poland(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-03-29 02:02:56 Bug #924: Segmentation fault in libpq/PQconsumeInput on SSL connection
Previous Message himansu biswal 2003-03-28 16:06:40 can you solve my problem