From: | Matthew <matt(at)ctlno(dot)com> |
---|---|
To: | "'Michael Ma '" <mikema(at)ficnet(dot)net>, "'pgsql-admin(at)postgresql(dot)org '" <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: [ADMIN] Can NOT dump db with 6.4.2's pg_dumpall |
Date: | 2000-02-19 23:49:32 |
Message-ID: | 183FA749499ED311B6550000F87E206C04E1E7@SRV |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm not sure if this will help but I just dealt with a similar problem.
When I tried to do a pg_dump it would fail. It turned out the culpret
was one single bad value in one row of one table. Any query that
returned that value would fail also, so I had to go through an
interitive process of select statements to identify the offending row.
Once I found it, I was able to delete the row, and everything worked
again.
Hope that helps, it was a bear of a problem for me.
-----Original Message-----
From: Michael Ma
To: pgsql-admin(at)postgresql(dot)org
Sent: 2/19/00 1:41 PM
Subject: [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(at)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
************
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Ma | 2000-02-20 07:49:19 | Re: [ADMIN] Can NOT dump db with 6.4.2's pg_dumpall |
Previous Message | Alberto Mainoni | 2000-02-19 22:57:12 | the beginners |