pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedconnections
4+ messages / 4 participants
[nested] [flat]
* connections
@ 2002-04-05 11:15 jaya <jayas@bsil.com>
0 siblings, 1 reply; 4+ messages in thread
From: jaya @ 2002-04-05 11:15 UTC (permalink / raw)
To: pgsql-admin
Hi,
The documentation on MAX_CONNECTIONS mentions default of 32 connections and a compiled in hard upper limit of 1024 connections. It also mentions that it can be altered when compiling the server.
Does this mean that the upper limit can be increased to more than 1024 at the time of server startup?
what will be the typical number of concurrent users if the MAX_CONNECTIONS is kept at 32 ?
WIll appreciate quick reply,
Regards
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: connections
@ 2002-04-05 11:43 postgresql@fruru.com
parent: jaya <jayas@bsil.com>
0 siblings, 0 replies; 4+ messages in thread
From: postgresql@fruru.com @ 2002-04-05 11:43 UTC (permalink / raw)
To: jaya <jayas@bsil.com>; +Cc: pgsql-admin
On Fri, 5 Apr 2002, jaya wrote:
> Hi, The documentation on MAX_CONNECTIONS mentions default of 32
> connections and a compiled in hard upper limit of 1024 connections. It
> also mentions that it can be altered when compiling the server.
>
> Does this mean that the upper limit can be increased to more than 1024
> at the time of server startup?
Guess so, if the server (and the libraries which the server uses) have
been configured and compiled to support more than 1024 concurrent
connections.
Why would you want more than 1024 simultaneous connections to the same
database instance ? (Perhaps some connection pooling could help reduce
your requirements)
> what will be the typical number of concurrent users if the
> MAX_CONNECTIONS is kept at 32 ?
I'm not sure what you mean, but I'd suppose it would be between 0 and 32...
Cheers
Tycho
--
Tycho Fruru tycho.fruru@conostix.com
Users' impressions of different operating systems, expressed as emoticons:
Linux: :)
Windows: XP
^ permalink raw reply [nested|flat] 4+ messages in thread
* Connections
@ 2004-12-08 15:07 Pascal Tufenkji <ptufenkji@usj.edu.lb>
0 siblings, 1 reply; 4+ messages in thread
From: Pascal Tufenkji @ 2004-12-08 15:07 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm using PostgreSQL 7.3.2
Is there a way to know if there are users connecting to my database (either via the web or telnet or whatever...)
I need that for in case I want to shut down the server, I want to know first if there are users still connecting to the database before shutting it down.
Thanx in adance
Pascal
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Connections
@ 2004-12-15 09:58 tsarevich@gmail.com
parent: Pascal Tufenkji <ptufenkji@usj.edu.lb>
0 siblings, 0 replies; 4+ messages in thread
From: tsarevich@gmail.com @ 2004-12-15 09:58 UTC (permalink / raw)
To: Pascal Tufenkji <ptufenkji@usj.edu.lb>; +Cc: pgsql-admin
On the bottom of this
page)http://www.varlena.com/varlena/GeneralBits/Tidbits/), there is a
script you can download called pgsession.
On Wed, 8 Dec 2004 17:07:56 +0200, Pascal Tufenkji <ptufenkji@usj.edu.lb> wrote:
> Hi,
> I'm using PostgreSQL 7.3.2
> Is there a way to know if there are users connecting to my database (either
> via the web or telnet or whatever...)
> I need that for in case I want to shut down the server, I want to know first
> if there are users still connecting to the database before shutting it down.
> Thanx in adance
> Pascal
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-12-15 09:58 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-05 11:15 connections jaya <jayas@bsil.com>
2002-04-05 11:43 ` postgresql@fruru.com
2004-12-08 15:07 Connections Pascal Tufenkji <ptufenkji@usj.edu.lb>
2004-12-15 09:58 ` Re: Connections tsarevich@gmail.com
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