Hi,

   Is there a compile option or any other tweak to restrict postgresql
data files size (the files that are usually under /usr/local/pgsql/data
directory) to a certain limit, for example no file should be bigger
that 10Mb. Thanks in advance

Wally

Fri, 19 Sep 2003 19:25:30 +0800 (PHT)
waldo.lacanlale@qualservcentral.com
postgresql system file size
waldo.lacanlale@qualservcentral.com writes:

>    Is there a compile option or any other tweak to restrict postgresql
> data files size (the files that are usually under /usr/local/pgsql/data
> directory) to a certain limit, for example no file should be bigger
> that 10Mb. Thanks in advance

Check out RELSEG_SIZE in src/include/pg_config.h.  The default is 1GB.

-- 
Peter Eisentraut   peter_e@gmx.net


Sat, 20 Sep 2003 19:23:49 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: postgresql system file size