Search Postgresql Archives

Re: Optimal values for 500 connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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@xxxxxxxxxxxxxx> 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-----


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux