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