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 B92C7D1B258 for ; Wed, 7 Jul 2004 15:27:32 -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 56884-05 for ; Wed, 7 Jul 2004 18:27:32 +0000 (GMT) Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by svr1.postgresql.org (Postfix) with ESMTP id 75516D1B23E for ; Wed, 7 Jul 2004 15:27:30 -0300 (ADT) Received: from panix3.panix.com (panix3.panix.com [166.84.1.3]) by mail1.panix.com (Postfix) with ESMTP id CDB8D4872C; Wed, 7 Jul 2004 14:27:30 -0400 (EDT) Received: (from adler@localhost) by panix3.panix.com (8.11.6p2-a/8.8.8/PanixN1.1) id i67IRUA13124; Wed, 7 Jul 2004 14:27:30 -0400 (EDT) Date: Wed, 7 Jul 2004 14:27:30 -0400 From: Michael Adler To: Hilary Forbes Cc: pgsql-admin@postgresql.org Subject: Re: Problems upgrading to 7.4 Message-ID: <20040707182730.GA12125@pobox.com> References: <5.1.0.14.0.20040707161638.05bb8b20@mailserver.dmr.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5.1.0.14.0.20040707161638.05bb8b20@mailserver.dmr.co.uk> User-Agent: Mutt/1.4.2.1i 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: 200407/88 X-Sequence-Number: 14156 On Wed, Jul 07, 2004 at 04:28:53PM +0100, Hilary Forbes wrote: > > ... when I run pg_dump to restore the data, one table with approx > 5.5 million records gives me > > ERROR: invalid memory alloc request size 1073741824 What do you mean "pg_dump to restore the data"? One would normally use psql or pg_restore to actually "restore" the data. In the past, that error message indicated some corrupted data that prevents a reading one or more rows in a table (and therefore prevents a pg_dump). But you seem to be saying that you can regularly dump that table without any problems. When can you dump the table? And when can you not dump the table? -Mike