Re: Optimal values for 500 connections

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thank you Scott!

As always your advice is right to the point ;-)
That solved it.

Best regards,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Scott Marlowe wrote:
> On Fri, Jun 26, 2009 at 12:52 PM, Pedro Doria
> Meunier<pdoria(at)netmadeira(dot)com> wrote:
>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>
>> Hi all,
>>
>> I'm wondering what are the correct values in postgresql.conf for
>> max_connections = 500 ...
>>
>> The values I had in 8.2.13 conf file worked without a problem but
>> with the new 8.3.7 postmaster simply refuses to start.
>>
>> Any pointers would be highly appreciated ;-)
>
> You likely need to increase max shared mem. With linux that's easy
> to do with
>
> sysctl -a|grep shm
>
> to get a list, and then copy and paste with changes to
> /etc/sysctl.conf. Look them up on the google, or in our docs, some
> good examples both places.
>
> Note that anytime the postmaster doesn't startup it tries to log it
> somewhere. Look for postmaster logs and such.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKRR2E2FH5GXCfxAsRAlisAJ940HUpld/VCn8acq773jNQq6WXoACfV1EK
lUC1q1tYr0U3g3FT7bii1ZE=
=BYKl
-----END PGP SIGNATURE-----