X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5761C9DCBC3 for ; Wed, 30 Nov 2005 10:45:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21370-08 for ; Wed, 30 Nov 2005 10:45:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 268EE9DCBAB for ; Wed, 30 Nov 2005 10:45:24 -0400 (AST) Received: from bell.credativ.de (p50896679.dip.t-dialin.net [80.137.102.121]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 897F3D764C; Wed, 30 Nov 2005 15:45:26 +0100 (CET) From: Peter Eisentraut To: "Tomeh, Husam" Subject: Re: upgrade database to 8.1 - 2GB file limit (pg_dump) Date: Wed, 30 Nov 2005 15:46:06 +0100 User-Agent: KMail/1.8.2 Cc: pgsql-admin@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511301546.06996.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/343 X-Sequence-Number: 19716 Am Mittwoch, 30. November 2005 15:17 schrieb Tomeh, Husam: > I'm upgrading from 8.0 to 8.1 on RedHat 2.6 kernel. I'm hitting the file > max limit of 2 GB file when I pg_dump my database (even if I compress > the dump file as it gets generated using a pipe). pg_dump is the > recommendation stated in the INSTALL doc to upgrade; what would be the > next recommendation to upgrade the database? Even though the 2 GB file size limit should be a thing of the past on modern Linux systems, if you can't figure it out, there are some tricks to reduce the file size listed here: http://www.postgresql.org/docs/8.0/static/backup.html#BACKUP-DUMP-LARGE -- Peter Eisentraut http://developer.postgresql.org/~petere/