Hello, We are running PostgreSQL 7.4.7 on a Linux system. We have a primary DB and hot-standby [via pg_dump/pg_restore]. A few weeks ago we had a database corruption and had to go back to a dump from 12/20/2006. Everything restored fine [on the primary and standby DB's] however everytime we perform a pg_dump/pg_restore we get this error:
pg_restore: creating TABLE account_password pg_restore: creating FUNCTION trig_account_insert() pg_restore: creating FUNCTION trig_account_password_insert() pg_restore: creating ACL trig_account_password_insert() pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60 pg_restore: *** aborted because of error Here is how we run the pg_dump command: pg_dump -C -v -U hydra -f <backup_file> -Fc hydra Here is how we run the pg_restore command: pg_restore -v -C -h bvmgdb2a -U hydra -d template1 <backup_file> I can get the pg_restore to complete if I add the -x [ignore ACL [grant/revoke]. But my question is what is wrong with the ACL trig_account_password_insert() and how can I fix it on the production DB so this error can go away? The error makes zero sense. The documentation leaves a lot to be desired. BTW I am a Sybase/SQL Server DBA so PostgreSQL is another world to me. Thanks, Shahryar -- Shahryar G. Hashemi DBA InfoSpace Inc. 601 108th Ave NE Suite 1200 Bellevue, WA 98004 U.S.A. Office: +1 425.201.8853 Fax: +1 425.201.6160 Alpha Pager: [EMAIL PROTECTED] Numeric Pager: +1 877.252.5631 E-Mail: [EMAIL PROTECTED] WEB: http://infospaceinc.com <http://infospaceinc.com/> This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s); any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. Thank you.
