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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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