From jayas@bsil.com Fri Apr 5 11:19:21 2002 Received: from bsil.com (unknown [202.54.18.42]) by postgresql.org (Postfix) with ESMTP id CFB6247545D for ; Fri, 5 Apr 2002 06:19:21 -0500 (EST) Received: from jayantsrv ([128.0.6.237]) by bsil.com (8.11.0/8.11.0) with SMTP id g35BFv615450 for ; Fri, 5 Apr 2002 16:45:58 +0530 Message-ID: <004001c1dc93$2c6f00e0$ed060080@jayantsrv> From: "jaya" To: Subject: connections Date: Fri, 5 Apr 2002 16:45:19 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003D_01C1DCC1.454FC8A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200204/56 X-Sequence-Number: 3945 This is a multi-part message in MIME format. ------=_NextPart_000_003D_01C1DCC1.454FC8A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 t= he 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 ------=_NextPart_000_003D_01C1DCC1.454FC8A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
The documentation on MAX_CONNECTIONS menti= ons=20 default of 32 connections and a compiled in hard upper limit of 1024=20 connections. It also mentions that it can be=20 altered when compiling the server.
 
Does this mean that the upper limit can be= =20 increased to more than 1024 at the time of server startup?
 
what will be the typical number of concurr= ent users=20 if the MAX_CONNECTIONS is kept at 32 ?
 
WIll appreciate quick reply,
 
Regards
 
 
------=_NextPart_000_003D_01C1DCC1.454FC8A0-- From postgresql@fruru.com Fri Apr 5 11:43:31 2002 Received: from perycles.unix.be.EU.org (unknown [195.207.52.190]) by postgresql.org (Postfix) with ESMTP id 45A8D475858 for ; Fri, 5 Apr 2002 06:43:31 -0500 (EST) Received: from localhost (fpmip@localhost) by perycles.unix.be.EU.org (8.11.6/8.11.2) with ESMTP id g35BhQD07907; Fri, 5 Apr 2002 13:43:26 +0200 Date: Fri, 5 Apr 2002 13:43:26 +0200 (CEST) From: postgresql@fruru.com X-X-Sender: fpmip@perycles.unix.be.EU.org To: jaya Cc: pgsql-admin@postgresql.org Subject: Re: connections In-Reply-To: <004001c1dc93$2c6f00e0$ed060080@jayantsrv> Message-ID: X-Swedish-Chef: Bork-Bork-Bork X-Plan: World Domination X-Message-Flag: Conostix. Making security work. MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/57 X-Sequence-Number: 3946 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 From ptufenkji@usj.edu.lb Fri Dec 10 21:57:59 2004 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 CEF0B3AB3CB for ; Fri, 10 Dec 2004 21:57:59 +0000 (GMT) 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 84527-04 for ; Fri, 10 Dec 2004 21:57:24 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id 1689E3AC538 for ; Fri, 10 Dec 2004 18:46:19 +0000 (GMT) Received: from rectorat2.usj.edu.lb (rectorat2.usj.edu.lb [193.227.187.132]) by svr4.postgresql.org (Postfix) with ESMTP id CE0725B066D for ; Wed, 8 Dec 2004 15:13:56 +0000 (GMT) Received: from pascal ([192.168.100.239]) by rectorat2.usj.edu.lb (8.11.6/8.11.6) with SMTP id iB8F9Se16981 for ; Wed, 8 Dec 2004 17:09:48 +0200 Message-ID: <020901c4dd37$d0363610$ef64a8c0@pascal> Reply-To: "Pascal Tufenkji" From: "Pascal Tufenkji" To: Subject: Connections Date: Wed, 8 Dec 2004 17:07:56 +0200 Organization: USJ MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01E2_01C4DD48.760E50D0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/74 X-Sequence-Number: 15660 This is a multi-part message in MIME format. ------=_NextPart_000_01E2_01C4DD48.760E50D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_01E2_01C4DD48.760E50D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
I'm using PostgreSQL = 7.3.2
Is there a way to know if there = are users=20 connecting to my database (either via the=20 web or telnet or whatever...)
I need that for in case I want to = shut down the=20 server, I want to know first if there are users still connecting to the = database=20 before shutting it down.
Thanx in adance
Pascal
------=_NextPart_000_01E2_01C4DD48.760E50D0-- From tsarevich@gmail.com Wed Dec 15 09:58:19 2004 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 CF9093AC268 for ; Wed, 15 Dec 2004 09:58:19 +0000 (GMT) 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 16116-03 for ; Wed, 15 Dec 2004 09:58:09 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.202]) by svr1.postgresql.org (Postfix) with ESMTP id F41BB3AC2B6 for ; Wed, 15 Dec 2004 09:58:10 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id a41so1233881rng for ; Wed, 15 Dec 2004 01:58:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=LkGuAs6X/33P1AhQ9vpd1Hx7V7NvA26L3H3cqw+hGmWuH4XNRlN65wdetxjYXX1g6AZaztL5WxHxn0cKaVYBN7mmyjiK4VGDNiy8KQlbgbcZZ4UJV95OIgfZgC+Rwkicli9Yt5dMoqP/lPKVi4sQSz8skXUyWSTS2AMImpM//Qs= Received: by 10.38.90.74 with SMTP id n74mr1734547rnb; Wed, 15 Dec 2004 01:58:10 -0800 (PST) Received: by 10.38.24.67 with HTTP; Wed, 15 Dec 2004 01:58:10 -0800 (PST) Message-ID: <156a90fe0412150158498f76e6@mail.gmail.com> Date: Wed, 15 Dec 2004 09:58:10 +0000 From: Reply-To: To: Pascal Tufenkji Subject: Re: Connections Cc: pgsql-admin@postgresql.org In-Reply-To: <020901c4dd37$d0363610$ef64a8c0@pascal> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <020901c4dd37$d0363610$ef64a8c0@pascal> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.202 tagged_above=0 required=5 tests=NO_REAL_NAME, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/137 X-Sequence-Number: 15723 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 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