Re: [HACKERS] 2 gig file size limit - Mailing list pgsql-patches

From Lamar Owen
Subject Re: [HACKERS] 2 gig file size limit
Date
Msg-id 01070710334002.07080@lowen.wgcr.org
Whole thread Raw
List 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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: encode in base code
Next
From: Damien Clermonté
Date:
Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword