X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 126D8D8133 for ; Mon, 17 Oct 2005 23:28:55 -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 47512-03 for ; Tue, 18 Oct 2005 02:28:50 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 71EE1D811E for ; Mon, 17 Oct 2005 23:28:52 -0300 (ADT) Received: from [192.168.1.100] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id j9I2PtvC013530; Mon, 17 Oct 2005 19:25:56 -0700 Message-ID: <43545E1D.7030302@commandprompt.com> Date: Mon, 17 Oct 2005 19:29:49 -0700 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Will Lewis Cc: pgsql-admin@postgresql.org Subject: Re: Fwd: Question: 2 GB file limit on linux References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Mon, 17 Oct 2005 19:25:57 -0700 (PDT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.021 required=5 tests=[AWL=0.021] X-Spam-Level: X-Archive-Number: 200510/205 X-Sequence-Number: 19277 Will Lewis wrote: >Hi, > >I sent this request recently but have heard nothing. > >I'm new to he whole procedure and may be doing this incorrectly. > > I don't know if anyone ever responded to you however the 2GB limit is an OLD limit and hasn't been an issue for at least 6 releases of RedHat. Sincerely, Joshua D. Drake >Please advise. > >Thanks >Will Lewis > >Database Administrator (DBA) >Central IT >Romney House >Bristol City Council >(0117 9222736) > > > > ------------------------------------------------------------------------ > > Subject: > Question: 2 GB file limit on linux > From: > "Will Lewis" > Date: > Wed, 05 Oct 2005 15:41:20 +0100 > To: > > > To: > > > >I saw a reference somewhere to a 2GB file limit when backing up Postgres databases on Linux. I can't remember where I saw it but our database is nearing 2 GB in size and concerns are creeping in. > >We are running Postgres 7.4 on Redhat AS4. > >Is this still a problem or has this been resolved on this version of Linux? > >Thanks >WL > > > >------------------------------------------------------------------------ > > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > > -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/