Skip site navigation (1) Skip section navigation (2)

Re: pg_dumpall failed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chen(at)musc(dot)edu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall failed
Date: 2004-09-20 14:40:25
Message-ID: 11352.1095691225@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Chuming Chen <chen(at)musc(dot)edu> writes:
> I am using  pg_dumpall (pg_dumpall -o > backup) to backup postgresql 
> 7.2.3 datatbase on Redhat Linux 8. It worked well, but recently, it 
> failed and gave me the following messages:

> pg_dump: query to get data of sequence "est_att_p_por_id_seq" returned 
> name "est_att_p_porites_id_seq"
> pg_dumap failed on xxxxx, exiting

> Can anybody tell me what might go wrong here?

You renamed the sequence.  pg_dump back then had a (misguided) consistency
check that would barf on renamed sequences.  If you don't mind hacking
the source code, it's a simple deletion of a few lines to take it out.

7.2.3 is pretty nearly ancient history; I'd suggest an update.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2004-09-20 15:49:13
Subject: Re: access rights
Previous:From: Chuming ChenDate: 2004-09-20 12:31:03
Subject: pg_dumpall failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group