pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Will Lewis <will_lewis@bristol-city.gov.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: Question: 2 GB file limit on linux
Date: Mon, 17 Oct 2005 11:13:15 +0530
Message-ID: <a97c77030510162243x65dc2ee6m8c4f1eabe711e30a@mail.gmail.com> (raw)
In-Reply-To: <s34b7e35.060@mail.bristol-city.gov.uk>
References: <s34b7e35.060@mail.bristol-city.gov.uk>

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 and
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 create
becuase that is going to limit the size of the database dump file. to verify
you may use dd command to create a file of say 5GB

$ dd if=/dev/zero of=test.dat bs=1024 count=5242880
$ ls -lh test.dat


Regds
Rajesh Kumar Mallah

On 10/11/05, Will Lewis <will_lewis@bristol-city.gov.uk> 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)
>
>



view thread (5+ messages)  latest in thread

Message-ID: <a97c77030510162243x65dc2ee6m8c4f1eabe711e30a@mail.gmail.com>
Permalink:  ../a97c77030510162243x65dc2ee6m8c4f1eabe711e30a@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030510162243x65dc2ee6m8c4f1eabe711e30a@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mallah.rajesh@gmail.com, will_lewis@bristol-city.gov.uk
  Subject: Re: Question: 2 GB file limit on linux
  In-Reply-To: <a97c77030510162243x65dc2ee6m8c4f1eabe711e30a@mail.gmail.com>
  References: <s34b7e35.060@mail.bristol-city.gov.uk> <a97c77030510162243x65dc2ee6m8c4f1eabe711e30a@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox