Обсуждение: 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) is now the default, continuing. SET TRANSACTION command failed. Explanation from backend: 'ERROR: parser: parse error at or near "transaction" '. pg_dump failed on cqn, exiting ======================================================================== My working platform is: RedHat Linux 6.0 with kernel 2.2.5-22 on a P-200 machine with 49M RAM. Can anybody help? Thanks in advance. Michael
Sounds like your two installations get mixed up. Make sure that the 6.5.2 commands are not in your path and that the 6.4.2 ones are. Btw., we're at 6.5.3 now. On 2000-02-20, Michael Ma mentioned: > 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) is now the default, continuing. > SET TRANSACTION command failed. Explanation from backend: 'ERROR: > parser: parse error at or near "transaction" > '. > pg_dump failed on cqn, exiting > ======================================================================== -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden