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 EB0A59DCBC3 for ; Wed, 30 Nov 2005 10:47:34 -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 21689-08 for ; Wed, 30 Nov 2005 10:47:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from presinet.com (presinet.com [209.53.156.1]) by postgresql.org (Postfix) with ESMTP id 087429DCAB1 for ; Wed, 30 Nov 2005 10:47:31 -0400 (AST) Received: from [10.10.1.151] ([10.10.1.151]) by presinet.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 30 Nov 2005 06:44:50 -0800 Message-ID: <438DBB87.1060703@presinet.com> Date: Wed, 30 Nov 2005 06:47:35 -0800 From: Bricklen Anderson User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Tomeh, Husam" CC: pgsql-admin@postgresql.org Subject: Re: upgrade database to 8.1 - 2GB file limit (pg_dump) References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Nov 2005 14:44:50.0453 (UTC) FILETIME=[9E117C50:01C5F5BC] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/344 X-Sequence-Number: 19717 Tomeh, Husam wrote: > > 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? Can I use the -Fc option > in pg_dump instead of the plain-text (default) ? Thanks in advance. > > --- > > Husam Tomeh How about using "split" to break up your file sizes? http://www.postgresql.org/docs/8.1/interactive/backup.html