Received: from mta01.mail.mel.aone.net.au (mta01.mail.au.uu.net [203.2.192.81]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4FAFJA10168 for ; Tue, 15 May 2001 06:15:20 -0400 (EDT) (envelope-from justin@postgresql.org) Received: from postgresql.org ([63.34.214.196]) by mta01.mail.mel.aone.net.au with ESMTP id <20010515101515.VXWM6842.mta01.mail.mel.aone.net.au@postgresql.org>; Tue, 15 May 2001 20:15:15 +1000 Message-ID: <3B01006E.1C716C07@postgresql.org> Date: Tue, 15 May 2001 20:09:50 +1000 From: Justin Clift X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.3-20mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: "S.E.Franke" , pgsql-sql@postgresql.org Subject: Re: error message... References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/140 X-Sequence-Number: 2957 Hi Sven, There is a startup option, "-N" of how many clients are allowed to be connected simultaneously. The default is 32 in the source code, not sure if SuSE has it changed. You can also alter the default maximum before compiling it, but I get the feeling you've installed pre-built packages. Where does SuSE put it's startup scripts? In /etc/rc.d/init.d ? If so, there should be something there relating to PostgreSQL, and it's this you should modify. If it starts PostgreSQL with "pg_ctl" then you'll need to pass the option -o '-N '. If it starts it with "postmaster", then use -N directly, without the -o. The man pages for pg_ctl and postmaster should be of some benefit also. Regards and best wishes, Justin Clift "S.E.Franke" wrote: > > Hi I have Postgres 7.0.3/6 on a Suse Professional 7.1 (kernel 2.4.0) > machine. > > The database is used very often and I see in the logfile the error > message: Sorry, too many clients already > > Can I set the number of 'active' clients? And where can I set this? And > How? > > Thanx in advance! > > Sven Franke > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi