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 8BCCDDA76D for ; Mon, 17 Oct 2005 02:43:17 -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 51101-01 for ; Mon, 17 Oct 2005 05:43:14 +0000 (GMT) Received: from qproxy.gmail.com (qproxy.gmail.com [72.14.204.193]) by svr1.postgresql.org (Postfix) with ESMTP id B1773DA721 for ; Mon, 17 Oct 2005 02:43:14 -0300 (ADT) Received: by qproxy.gmail.com with SMTP id u24so138253qbh for ; Sun, 16 Oct 2005 22:43:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=LU4INTFqrVl2imcF1s1uWZE2/bLgsCP9XD+4qNu/gkPEPjxLM1huiKTsa69zbZjBshtLHlsmtJObr7inbkAB/m7q7137XAICXsnxY3xKZ5uAefViaLj6pU2SK2to2AC7YnuHOGBea3gDWURpD6tpsCBFBao95KTVIE67ZMBu7UE= Received: by 10.64.250.20 with SMTP id x20mr1690583qbh; Sun, 16 Oct 2005 22:43:15 -0700 (PDT) Received: by 10.64.156.9 with HTTP; Sun, 16 Oct 2005 22:43:15 -0700 (PDT) Message-ID: Date: Mon, 17 Oct 2005 11:13:15 +0530 From: Rajesh Kumar Mallah To: Will Lewis Subject: Re: Question: 2 GB file limit on linux Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/188 X-Sequence-Number: 19260 Hi Will, There is not much reason of concern. Firstly the limit is not on the size of database that postgres can handle, it is on the size of a single file that can be created on the filesystem an= d the total size of filesystem. We have database of 18GB and compressed dump files are between 2-3 GB. On modern linux system the size of single file and files system is quite large which depends on filesystem type , architecture (32bit or 64bit) , glibc version and (may be other things). Refer Below for some info. http://linuxreviews.org/sysadmin/filesystems/ It may be a good idea to VERIFY the largest size of file that you can creat= e becuase that is going to limit the size of the database dump file. to verif= y you may use dd command to create a file of say 5GB $ dd if=3D/dev/zero of=3Dtest.dat bs=3D1024 count=3D5242880 $ ls -lh test.dat Regds Rajesh Kumar Mallah On 10/11/05, 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. > > Please advise. > > Thanks > Will Lewis > > Database Administrator (DBA) > Central IT > Romney House > Bristol City Council > (0117 9222736) > >