[ADMIN] Can NOT dump db with 6.4.2's pg_dumpall

Hi, In order to upgrade from 6.4.2 to 6.5.2, I tried to dump my db by typing [postgres@redhat60 pgsql]$ pg_dumpall -z > db.out Instead of getting a dump file, I got the following message. pg_dump: The -z option(dump ACLs)

Re: [ADMIN] Can NOT dump db with 6.4.2's pg_dumpall

Hi, Matthew I have tried to dump tables one by one to identify the table contains bad value. However I got the following error messages from each dump. .. SET TRANSACTION command failed. Explanation from backend: 'ERROR: parser: parse error at or near "transaction"'. .. May I