Can NOT dump db with 6.4.2's pg_dumpall - Mailing list pgsql-admin

From Michael Ma
Subject Can NOT dump db with 6.4.2's pg_dumpall
Date
Msg-id 38AEF1F8.DEC50A7D@ficnet.net
Whole thread Raw
Responses Re: [ADMIN] Can NOT dump db with 6.4.2's pg_dumpall
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [ADMIN] Backup of db with large objects.
Next
From: Alberto Mainoni
Date:
Subject: the beginners