too many clients

Started by jochen maderalmost 25 years ago4 messagesgeneral
Jump to latest
#1jochen mader
jochen@teg-me.de

First: Thanks to the postgresteam for the fine work. In our corporation
postgres has replaced adabas 11 and is doing a real good job.

Second: At the moment I've got the following poblem:
Form time to time (at the moment it's happening more and more often) I'me
getting the following errormessage: Sorry, too man clients already connected
Is it possible to increase the maximum number of simultanous connections?
If not is there any way to say that one database is allowed to get more
connections than another?

Thanks in advance
jochen

#2Nicolas Huillard
nhuillard@ghs.fr
In reply to: jochen mader (#1)
RE: too many clients

Look at the -N (and -B) options of the postmaster process (for 6.5.3, maybe different for 7.x)

NH

Show quoted text

-----Message d'origine-----
De: jochen mader [SMTP:jochen@teg-me.de]
Date: vendredi 8 juin 2001 13:53
�: pgsql-general@postgresql.org
Objet: [GENERAL] too many clients

First: Thanks to the postgresteam for the fine work. In our corporation
postgres has replaced adabas 11 and is doing a real good job.

Second: At the moment I've got the following poblem:
Form time to time (at the moment it's happening more and more often) I'me
getting the following errormessage: Sorry, too man clients already connected
Is it possible to increase the maximum number of simultanous connections?
If not is there any way to say that one database is allowed to get more
connections than another?

Thanks in advance
jochen

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#3Christian Bucanac
christian.bucanac@mindark.com
In reply to: Nicolas Huillard (#2)
RE: too many clients

Hi!

Use the -N flag to set number of client connections when starting
postmaster. See manual page for postmaster.

/Buckis

-----Original Message-----
From: jochen mader [mailto:jochen@teg-me.de]
Sent: den 8 juni 2001 13:53
To: pgsql-general@postgresql.org
Subject: [GENERAL] too many clients

First: Thanks to the postgresteam for the fine work. In our corporation
postgres has replaced adabas 11 and is doing a real good job.

Second: At the moment I've got the following poblem:
Form time to time (at the moment it's happening more and more often) I'me
getting the following errormessage: Sorry, too man clients already connected
Is it possible to increase the maximum number of simultanous connections?
If not is there any way to say that one database is allowed to get more
connections than another?

Thanks in advance
jochen

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#4jochen mader
jochen@teg-me.de
In reply to: Nicolas Huillard (#2)
Re: too many clients

On Friday 08 June 2001 16:45, you wrote:

Look at the -N (and -B) options of the postmaster process (for 6.5.3, maybe
different for 7.x)

Thanks a lot, overlooked this one :-)