Fwd: Question: 2 GB file limit on linux

["Will Lewis" <will_lewis@xxxxxxxxxxxxxxxxxxx>]

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)

--- Begin Message ---

• To: <pgsql-admin@xxxxxxxxxxxxxx>
• Subject: Question: 2 GB file limit on linux
• From: "Will Lewis" <will_lewis@xxxxxxxxxxxxxxxxxxx>
• Date: Wed, 05 Oct 2005 15:41:20 +0100

I saw a reference somewhere to a 2GB file limit when backing up Postgres databases on Linux. I can't remember where I saw it but our database is nearing 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?

Thanks
WL

--- End Message ---

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend