The following bug has been logged online:
Bug reference: 4425
Logged by: Kieran McCusker
Email address: kieran.mccusker@kwest.info
PostgreSQL version: 8.3.3
Operating system: Linux (fc9)
Description: cannot pg_restore from pg_dump --format=c
Details:
Hi
I'm trying to copy a database between two servers (both fc9).
If I do the following:-
pg_dump --format=c --username=portal --file=test.dump Portal
Create the database using:-
createdb -E utf8 --owner=portal --template postgres Portal
then:
pg_restore --dbname=Portal test.dump
The database schema is partially restored and no data added.
If I do the same thing using pg_dump --format=p and loading it using psql it
works fine. The database was originally created under fc7 (sorry can't
remember the version) Its a bit worrying as it means the previous nightly
backups are not usable.