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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Will Lewis" <will_lewis(at)bristol-city(dot)gov(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Fwd: Question: 2 GB file limit on linux
Date: 2005-10-17 05:00:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"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

In response to


pgsql-admin by date

Next:From: Rajesh Kumar MallahDate: 2005-10-17 05:01:03
Subject: possibly outdated info in pg_stat_activity
Previous:From: Ilias GoudaropoulosDate: 2005-10-16 20:59:27
Subject: 8.0.3 Anoying installer error

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