pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Max Conncection limit?
2+ messages / 2 participants
[nested] [flat]

* Max Conncection limit?
@ 2001-03-13 16:33 Najm Hashmi <najm@mondo-live.com>
  2001-03-12 17:46 ` Re: Max Conncection limit? Frank Joerdens <frank@joerdens.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Najm Hashmi @ 2001-03-13 16:33 UTC (permalink / raw)
  To: pgsql-sql

We  start a server and initiate 30 connections(with the libpq C interface)
which are  stored in a stack to  use and  and to be reused.

After awhile I try to start another server that will also try to initiate 30
connections, for each connection I then get a PQErrorMessage like that :
"Sorry, too many connections"

if I do a ps -ax at that time I get a lot of /usr/bin/postgres 192.168.0.1
user name passwd   idle

what I usually do is restart postgres but I wish I didnt have to do that...
That is not an elegant solutuion any ways.
What can I do? Thanks in advance. Regards

Attachments:

najm.vcf (text/x-vcard, 183B) download begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: Max Conncection limit?
  2001-03-13 16:33 Max Conncection limit? Najm Hashmi <najm@mondo-live.com>
@ 2001-03-12 17:46 ` Frank Joerdens <frank@joerdens.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Frank Joerdens @ 2001-03-12 17:46 UTC (permalink / raw)
  To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql

On Tue, Mar 13, 2001 at 11:33:10AM -0500, Najm Hashmi wrote:
> We  start a server and initiate 30 connections(with the libpq C interface)
> which are  stored in a stack to  use and  and to be reused.
> 
> After awhile I try to start another server that will also try to initiate 30
> connections, for each connection I then get a PQErrorMessage like that :
> "Sorry, too many connections"
> 
> if I do a ps -ax at that time I get a lot of /usr/bin/postgres 192.168.0.1
> user name passwd   idle
> 
> what I usually do is restart postgres but I wish I didnt have to do that...
> That is not an elegant solutuion any ways.
> What can I do? Thanks in advance. Regards

Have a look at the runtime-config.html in the admin section of the
manual:

MAX_CONNECTIONS (integer)

Determines how many concurrent connections the database server will
allow. The default is 32. There is also a compiled-in hard upper limit
on this value, which is typically 1024 (both numbers can be altered when
compiling the server). This parameter can only be set at server start. 

Regards, Frank



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-13 16:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-13 16:33 Max Conncection limit? Najm Hashmi <najm@mondo-live.com>
2001-03-12 17:46 ` Frank Joerdens <frank@joerdens.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox