The following bug has been logged online: Bug reference: 4431 Logged by: Kieran McCusker Email address: [EMAIL PROTECTED] 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 postgresql version) Its a bit worrying as it means none of the previous nightly backups are usable. I can provide the dump if needed (its 230Mb compressed 1.8Gib uncompressed) Many thanks Kieran -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
