Обсуждение: Bug #923: psql can't read file prepaired by pg_dumpall

Поиск
Список
Период
Сортировка

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

От
pgsql-bugs@postgresql.org
Дата:
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