Skip site navigation (1) Skip section navigation (2)

Re: Fwd: Question: 2 GB file limit on linux

From: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Will Lewis <will_lewis(at)bristol-city(dot)gov(dot)uk>,pgsql-admin(at)postgresql(dot)org
Subject: Re: Fwd: Question: 2 GB file limit on linux
Date: 2005-10-24 14:23:07
Message-ID: 435CEE4B.9080808@mail.jct.ac.il (view raw or flat)
Thread:
Lists: pgsql-admin
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" <will_lewis(at)bristol-city(dot)gov(dot)uk> 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


In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2005-10-24 15:28:02
Subject: Re: [PERFORM] Need help in setting optimal configuration
Previous:From: Kishore BDate: 2005-10-23 21:55:50
Subject: Re: [PERFORM] Need help in setting optimal configuration for a huge database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group