mike south ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is.
Short Description un-pg_restore-able pg_dump Long Description HI, I'm trying to do a dump/restore on a database. I created the dump like this: pg_dump -u -Fc db_xref_qa >db_xref_qa.dump I attempted to restore it like this: [postgres@chef postgres]$ pg_restore -u -Fc -d remove_this_db db_xref_qa.dump and this is the output: Username: postgres Password: Connecting to remove_this_db as postgres Password: Connecting to remove_this_db as kerneladmin Password: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'kernel_maker_pkey' for table 'kernel_maker' NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'kernel_status_pkey' for table 'kernel_status' NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'kernel_pkey' for table 'kernel' NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'netraverse_kernel_pkey' for table 'netraverse_kernel' NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'obsolete_kernel_group_pkey' for table 'obsolete_kernel_group' NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'stock_kernel_pkey' for table 'stock_kernel' Connecting to remove_this_db as postgres Password: Archiver(db): Could not execute query. Code = 7. Explanation from backend: 'ERROR: Relation 'test2' does not exist '. I also did a plain dump ( pg_dump -u db_xref_qa >db_xref_qa.plaindump ), and when I looked through it I noticed (I gather from the bug reporting instructions that I am not supposed to speculate about what the problem is, so you may stop reading now) that the lines to create the ACL entry on the view "test2" came before the lines that created the view "test2". An excerpt from db_xref_qa.plaindump, in which TOC entry ID 24 precedes TOC Entry ID 23, (which looked odd to me, but what do I know?): [begin excerpt]-- -- TOC Entry ID 24 (OID 187523) -- -- Name: test2 Type: ACL Owner: -- REVOKE ALL on "test2" from PUBLIC; GRANT ALL on "test2" to "postgres"; GRANT ALL on "test2" to "kerneladmin"; -- -- TOC Entry ID 23 (OID 187533) -- -- Name: test2 Type: VIEW Owner: postgres -- CREATE VIEW "test2" as ((SELECT [end excerpt] I have the full dump, both with -Fc and plain, at http://fulcrum.org/test/db_xref_qa.dump.gz and http://fulcrum.org/test/db_xref_qa.plaindump.gz in case that might be helpful. mike Sample Code No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
