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 39F1AD1B19A for ; Sun, 13 Jun 2004 04:53:42 -0300 (ADT) 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 13788-07 for ; Sun, 13 Jun 2004 07:53:38 +0000 (GMT) Received: from mail.unisoftbg.com (unknown [194.12.229.207]) by svr1.postgresql.org (Postfix) with ESMTP id 1DFE3D1B19F for ; Sun, 13 Jun 2004 04:53:34 -0300 (ADT) Received: (qmail 12400 invoked by uid 507); 13 Jun 2004 08:00:44 -0000 Received: from unknown (HELO t1.unisoftbg.com) (194.12.229.193) by 0 with SMTP; 13 Jun 2004 08:00:44 -0000 Message-ID: <40CBF62A.3000602@t1.unisoftbg.com> Date: Sun, 13 Jun 2004 08:37:30 +0200 From: pginfo User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: problem with pg_dump Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL X-Spam-Level: * X-Archive-Number: 200406/155 X-Sequence-Number: 13815 Hi all, We are using pg as db for many erp installations. In general it is working great. But at the monet I have problem (I think it is database corrupted, but I am not sure) by running pg_dump. I receive this message: pg_dump acc01 > dmpacc01 pg_dump: query to obtain list of data types failed: ERROR: More than one tuple returned by a subselect used as an expression. I can not find nothink wong in my log-file. The lastest records are: LOG: shutting down LOG: database system is shut down LOG: database system was shut down at 2004-06-13 09:39:03 EEST LOG: checkpoint record is at 3/313382E4 LOG: redo record is at 3/313382E4; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 4046855; next oid: 958527775 LOG: database system is ready WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress WARNING: ROLLBACK: no transaction in progress ERROR: More than one tuple returned by a subselect used as an expression. We are using pg 7.3.4 for this install (we will upgrade to 7.4.x soon). Pls. help me to sort out this problem. It is production db and is important to resolve the problem. regards, ivan.