X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FFF9329D3C for ; Mon, 20 Sep 2004 13:31:17 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20471-09 for ; Mon, 20 Sep 2004 12:31:10 +0000 (GMT) Received: from mopsy2.ccit.musc.edu (mopsy2.ccit.musc.edu [128.23.34.56]) by svr1.postgresql.org (Postfix) with ESMTP id 128F9329CDB for ; Mon, 20 Sep 2004 13:31:12 +0100 (BST) Received: from revere3.musc.edu (revere3.musc.edu [128.23.203.9]) by mopsy2.ccit.musc.edu (8.12.10/8.12.10) with ESMTP id i8KCV8bM012680 for ; Mon, 20 Sep 2004 08:31:08 -0400 Received: from cottontail.musc.edu (cottontail.musc.edu [128.23.203.163]) by revere3.musc.edu (8.12.9/8.12.9) with ESMTP id i8KCV8bp011679 for ; Mon, 20 Sep 2004 08:31:08 -0400 (EDT) Received: from [128.23.116.83] ([128.23.116.83]) (authenticated bits=0) by cottontail.musc.edu (8.12.10/8.12.10) with ESMTP id i8KCV7JE017732 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Mon, 20 Sep 2004 08:31:08 -0400 Message-ID: <414ECD87.4040602@musc.edu> Date: Mon, 20 Sep 2004 08:31:03 -0400 From: Chuming Chen Reply-To: chen@musc.edu Organization: Department of Biostatistics, Bioinformatics and Epidemiology, Medical University of South Carolina User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-MUSC-MailScanner-Information: Please contact postmstr@musc.edu for more information X-MUSC-MailScanner: Found to be clean X-MUSC-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=0, required 4) X-MailScanner-From: chen@musc.edu Subject: pg_dumpall failed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/170 X-Sequence-Number: 14873 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: 843-792-1555 (O)