pg_dumpall failed

[Chuming Chen]

Hi, all,

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?

Thank you very much for your kind reply.
--
Chuming Chen
System Administrator & Programmer
Department of Biostatistics, Bioinformatics and Epidemiology
Medical University of South Carolina
135 Cannon Street, Suite 303
Charleston SC 29425
Tel: [phone] (O)


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Post by Chuming Chen
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
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html