migration - Mailing list pgsql-general

From P. Jourdan
Subject migration
Date
Msg-id 5.1.0.14.2.20020410182838.00ae7908@mail.host45.com
Whole thread Raw
List pgsql-general
I want to restore a database from a gzipped file: backups were done as
complete files (not partial). Original was dumped from Postgresql 7.0.3.
The dump, ungzipped is filename.psql. pg_restore does not recognize it. The
command psql -d database -f filename.psql does restore it partly, but with
numerous errors and the file is basically useless.
I am told to install the earlier version of Postgresql to restore, but that
seems to be a problem. Even if that works, how can the restored database be
migrated to a new version of Postgresql?
Thanks for any help.
P. Jourdan



pgsql-general by date:

Previous
From: "Andrew Bartley"
Date:
Subject: "Bad date external representation '2002-04-09 00:02:60.00+10'".
Next
From: Gunther Schadow
Date:
Subject: Critical performance problems on large databases