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 CED47DAAF1 for ; Mon, 24 Oct 2005 10:28:27 -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 24790-06 for ; Mon, 24 Oct 2005 13:28:22 +0000 (GMT) Received: from mail3.cc.huji.ac.il (mail3.cc.huji.ac.il [132.64.1.21]) by svr1.postgresql.org (Postfix) with ESMTP id 109F2DAA6D for ; Mon, 24 Oct 2005 10:28:23 -0300 (ADT) Received: from mail3.cc.huji.ac.il (localhost [127.0.0.1]) by mail3.cc.huji.ac.il (Postfix) with SMTP id DEF69C0E76; Mon, 24 Oct 2005 15:28:22 +0200 (IST) Received: by mail3.cc.huji.ac.il (Postfix, from userid 31998) id 8B678C1750; Mon, 24 Oct 2005 15:19:33 +0200 (IST) Received: from [132.64.42.93] (di8-42093.dialin.huji.ac.il [132.64.42.93]) by mail3.cc.huji.ac.il (Postfix) with ESMTP id F0AC5C1751; Mon, 24 Oct 2005 15:19:32 +0200 (IST) Message-ID: <435CEE4B.9080808@mail.jct.ac.il> Date: Mon, 24 Oct 2005 16:23:07 +0200 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Will Lewis , pgsql-admin@postgresql.org Subject: Re: Fwd: Question: 2 GB file limit on linux References: <12821.1129525234@sss.pgh.pa.us> In-Reply-To: <12821.1129525234@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.922 from Sun Oct 23 18:10:17 2005 CET X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.03 required=5 tests=[AWL=0.030] X-Spam-Level: X-Archive-Number: 200510/252 X-Sequence-Number: 19324 we are using 7.4 with more than 2G and dump restore works fine (suse 9).of course that does not mean it will work fine for you... evgeny Tom Lane wrote: > "Will Lewis" writes: > >>I saw a reference somewhere to a 2GB file limit when backing up Postgres da= >>tabases on Linux. I can't remember where I saw it but our database is neari= >>ng 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? > > > It probably works, but if you're worried you should test it directly. > Create a scratch database, load a few GB of data, see if the backup and > restore procedures you are currently using choke. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster