Thread: 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