Re: [HACKERS] 2 gig file size limit

Re: [HACKERS] 2 gig file size limit

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