X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1F5F3D1B2D9 for ; Sun, 25 Jul 2004 20:03:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48046-03 for ; Sun, 25 Jul 2004 23:03:38 +0000 (GMT) Received: from pns.mm.eutelsat.org (pns.mm.eutelsat.org [194.214.173.227]) by svr1.postgresql.org (Postfix) with ESMTP id CCB95D1B1B4 for ; Sun, 25 Jul 2004 20:03:33 -0300 (ADT) Received: from nts-03.mm.eutelsat.org (localhost [127.0.0.1]) by pns.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id i6PN3P203099; Mon, 26 Jul 2004 01:03:25 +0200 Received: from [127.0.0.1] (accesspoint.mm.eutelsat.org [194.214.173.4]) by nts-03.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id i6PN3YX04534; Mon, 26 Jul 2004 01:03:34 +0200 Message-ID: <41043C35.2080909@bigfoot.com> Date: Mon, 26 Jul 2004 01:03:17 +0200 From: Gaetano Mendola User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Roberto De Shong , "pgsql-admin@postgresql.org" Subject: Re: Can't increase max connections References: <20040719163859.1354.qmail@web40411.mail.yahoo.com> In-Reply-To: <20040719163859.1354.qmail@web40411.mail.yahoo.com> X-Enigmail-Version: 0.84.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/287 X-Sequence-Number: 14355 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Roberto De Shong wrote: | I have installed PostgreSQL 7.3 on FreeBSD 4.10 Stable, and have been | trying to increase the max connections. the most I'm able to is 40, if I | increase it any higher I'm unable to start the database. Is there any | tip, s hte any guide where I can get an idea of the other values to set | in postgresql.conf for increasing max connections? I had also recompile | the kernel and changed maxusers from 0 to 64. I'm not sure if increasing | it even more would allow me increase connections. Would appreciate some | help, thanks. Most likely you are out of shared memory segments that you OS allow. If you are on Linux try to pump-up shmmax and shmall Regards Gaetano Mendola -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBBDwz7UpzwH2SGd4RAmO7AJ4jqXpBjglSZuwn7e92wRS23sJR+QCgkpLE vK2twgkJ8Wi80vM+5KzWymg= =C9sb -----END PGP SIGNATURE-----