Will Lewis wrote:
Hi,
I sent this request recently but have heard nothing.
I'm new to he whole procedure and may be doing this incorrectly.
I don't know if anyone ever responded to you however the 2GB limit is an
OLD limit and hasn't been an issue
for at least 6 releases of RedHat.
Sincerely,
Joshua D. Drake
Please advise.
Thanks
Will Lewis
Database Administrator (DBA)
Central IT
Romney House
Bristol City Council
(0117 9222736)
------------------------------------------------------------------------
Subject:
Question: 2 GB file limit on linux
From:
"Will Lewis" <will_lewis@xxxxxxxxxxxxxxxxxxx>
Date:
Wed, 05 Oct 2005 15:41:20 +0100
To:
<pgsql-admin@xxxxxxxxxxxxxx>
To:
<pgsql-admin@xxxxxxxxxxxxxx>
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 of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
