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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc pgsql-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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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

Browse pgsql-jdbc by date

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

Browse pgsql-patches by date

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