The following bug has been logged online: Bug reference: 4425 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 version) Its a bit worrying as it means the previous nightly backups are not usable. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
