X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7176CD1D285 for ; Mon, 26 Jan 2004 12:51:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44421-07 for ; Mon, 26 Jan 2004 08:50:51 -0400 (AST) Received: from bitoek.uni-bayreuth.de (bti0x1.bitoek.uni-bayreuth.de [132.180.112.2]) by svr1.postgresql.org (Postfix) with ESMTP id 85464D1B462 for ; Mon, 26 Jan 2004 08:50:43 -0400 (AST) Received: from bitoek.uni-bayreuth.de (bti0x027.bitoek.uni-bayreuth.de [132.180.112.27]) by bitoek.uni-bayreuth.de (8.12.7/8.12.7) with ESMTP id i0QCoiYm026940 for ; Mon, 26 Jan 2004 13:50:44 +0100 Message-ID: <40150D23.8000903@bitoek.uni-bayreuth.de> Date: Mon, 26 Jan 2004 13:50:43 +0100 From: Stefan Holzheu User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.4) Gecko/20030624 X-Accept-Language: de-at, de, en-us, en MIME-Version: 1.0 To: ADMIN Subject: Problems with pg_dump Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS - amavis-milter (http://www.amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/210 X-Sequence-Number: 12073 Two weeks ago we did an upgrade from postgresql 7.3.2 to 7.4.1. No we have the problem that pg_dump does not finish. We get the following error message: pg_dump: lost synchronization with server: got message type "5", length 842281016 pg_dump: SQL command to dump the contents of table "aggr_stddev_hour" failed: PQendcopy() failed. pg_dump: Error message from server: lost synchronization with server: got message type "5", length 842281016 pg_dump: The command was: COPY messungen.aggr_stddev_hour (id, von, wert, counts) TO stdout; The database size is about 10 GB. OS is Redhat Linux 7.1. Help appreciated! Stefan -- ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth -----------------------------