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

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 (view raw or flat)
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

pgsql-admin by date

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

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