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
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? |
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 |
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 |
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 |