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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
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-18 02:29:49
Message-ID: 43545E1D.7030302@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)bristol-city(dot)gov(dot)uk>
> Date:
> Wed, 05 Oct 2005 15:41:20 +0100
> To:
> <pgsql-admin(at)postgresql(dot)org>
>
> To:
> <pgsql-admin(at)postgresql(dot)org>
>
>
>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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-10-18 02:37:46 Re: error: permission denied for schema pg_catalog && pg_temp_nn tables
Previous Message Guido Barosio 2005-10-18 02:16:11 error: permission denied for schema pg_catalog && pg_temp_nn tables