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

Re: [HACKERS] 2 gig file size limit

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: Naomi Walker <nwalker(at)eldocomp(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-patches(at)postgresql(dot)org" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] 2 gig file size limit
Date: 2001-07-07 14:33:40
Message-ID: 01070710334002.07080@lowen.wgcr.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-jdbcpgsql-patches
On Friday 06 July 2001 18:51, Naomi Walker wrote:
> If PostgreSQL is run on a system that has a file size limit (2 gig?), where
> might cause us to hit the limit?

Since PostgreSQL automatically segments its internal data files to get around 
such limits, the only place you will hit this limit will be when making 
backups using pg_dump or pg_dumpall.  You may need to pipe the output of 
those commands into a file splitting utility, and then you'll have to pipe 
through a reassembly utility to restore.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Responses

pgsql-hackers by date

Next:From: Lamar OwenDate: 2001-07-07 14:36:29
Subject: Re: Pg on SMP half-powered
Previous:From: Lincoln YeohDate: 2001-07-07 08:17:57
Subject: Re: [GENERAL] Vacuum and Transactions

pgsql-jdbc by date

Next:From: Anders BengtssonDate: 2001-07-08 15:26:57
Subject: [PATCH] Cleanup of JDBC character encoding
Previous:From: Larry RosenmanDate: 2001-07-07 00:12:05
Subject: Re: [HACKERS] 2 gig file size limit

pgsql-patches by date

Next:From: Peter EisentrautDate: 2001-07-08 07:47:45
Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword
Previous:From: Bruce MomjianDate: 2001-07-07 04:10:04
Subject: Re: encode in base code

pgsql-general by date

Next:From: Lamar OwenDate: 2001-07-07 14:43:35
Subject: Re: PostgreSQL perl / libpq.so.2 problem - again :(
Previous:From: Ryan MahoneyDate: 2001-07-07 13:38:10
Subject: Re: RedHat Open Database?

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