Re: Initial max_connections for initdb on FreeBSD.

Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160
>
>
> I've got a BSD system I work on that is jailed and has low shared
> memory settings. So low that I cannot even initdb to create a test
> 8.3.1 database. It tries to create template1 with shared_buffers of
> 50 and max_connections of 13. Is there any way to tweak those during
> initdb? Should there or can there be? Is there another way around
> this problem that can be somewhat automated? For my testing purposes,
> I don't need high settings at all (max_connections could be 2, for
> example).
>

From the manual I get -

initdb uses uses the environment variables supported by libpq

PGOPTIONS sets additional run-time options for the PostgreSQL server

postgres -

-B nbuffers
Sets the number of shared buffers for use by the server processes. The
default value of this parameter is chosen automatically by initdb.
Specifying this option is equivalent to setting the shared_buffers
configuration parameter.

-N max-connections
Sets the maximum number of client connections that this server will
accept. The default value of this parameter is chosen automatically by
initdb. Specifying this option is equivalent to setting the
max_connections configuration parameter.

So I would try something like -

setenv PGOPTIONS -N 2 -B 10 (or export depending on shell)
initdb -D /path/to/data

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz