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 7EB23D1CCA6 for ; Mon, 26 Jan 2004 15:31:43 +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 03276-08 for ; Mon, 26 Jan 2004 11:31:16 -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 EE710D1D23E for ; Mon, 26 Jan 2004 11:31:10 -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 i0QFVDYm029765; Mon, 26 Jan 2004 16:31:13 +0100 Message-ID: <401532C0.5010402@bitoek.uni-bayreuth.de> Date: Mon, 26 Jan 2004 16:31:12 +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: Tom Lane Cc: ADMIN Subject: Re: Problems with pg_dump References: <40150D23.8000903@bitoek.uni-bayreuth.de> <7276.1075127998@sss.pgh.pa.us> In-Reply-To: <7276.1075127998@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS - amavis-milter (http://www.amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/214 X-Sequence-Number: 12077 >=20 >>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=20 >>following error message: >=20 >=20 >>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"=20 >>failed: >=20 >=20 > That's interesting. What are the column data types in that table? What > character set encoding are you using? Can you do a dump if you select > the dump-data-as-INSERT-commands option? Tabelle =BBmessungen.aggr_stddev_hour=AB Spalte | Typ | Attribute --------+--------------------------+----------- id | integer | not null von | timestamp with time zone | not null wert | double precision | counts | integer | not null Indexe: =BBidx_aggr_stddev_hour_id_von=AB eindeutig, btree (id, von) Encoding: LATIN9 The error does not occur always and not always with the same table.=20 However, the error occurs only on that kind of aggregation tables. There=20 is a cron-job keeping the tables up to date, starting all 10 minutes.=20 The job does delete and inserts on the table. Could this somehow block=20 the dump process? Normally it should not? >=20 >=20 >>The database size is about 10 GB. >=20 >=20 > How big is the particular table? The table has 9 000 000 entries. Stefan --=20 ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5799 BITOeK Wiss. Sekretariat Universitaet Bayreuth D-95440 Bayreuth -----------------------------