Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5DB562E00A0 for ; Fri, 30 Nov 2007 16:03:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 71499-05 for ; Fri, 30 Nov 2007 16:03:30 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.236]) by postgresql.org (Postfix) with ESMTP id 4A0C22E0181 for ; Fri, 30 Nov 2007 16:03:33 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so1862330nzf for ; Fri, 30 Nov 2007 12:03:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=jCMScXtW8N48ugN0bBKcYryfiWyUkSGi9X7U2vrjLRM=; b=iBkgzmCMgz+IOMvG9FoLfM/DgYAtKzRghndp/smolXG8ZGWdbfjPARYYEwGwKsmPybhHRqU0L+MJlr26IFflNNI+SfPQ59eM4rFIrpO/PZhTzr29MiuagzUKJW2CGzzSKf8eTETSvlUNwyN0ixgBdr8PA7lkHQBvf0ahRmW4aCQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=MEtHfdXv+Ec2ZDy6ay0diEA94LtmuAKw/2GWb/0hfc7D2j70S5rJ6VnJC9dNY47lQApZyO48jBy/9eFkZ65KUsqbR9qxtB9etNjvLglchprwrt3UiGlvn8KCx+WFIQTWUFkszqyD5TIJskRgydXpaqhiJO7YSzoK8J+lrtgPvWw= Received: by 10.142.101.17 with SMTP id y17mr2746270wfb.1196453011836; Fri, 30 Nov 2007 12:03:31 -0800 (PST) Received: by 10.143.19.7 with HTTP; Fri, 30 Nov 2007 12:03:31 -0800 (PST) Message-ID: <36e682920711301203g7fdb1b81vc7d2bbb2e4018827@mail.gmail.com> Date: Fri, 30 Nov 2007 15:03:31 -0500 From: "Jonah H. Harris" To: "Tena Sakai" Subject: Re: connection limit exceeded Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/252 X-Sequence-Number: 27495 On Nov 30, 2007 2:55 PM, Tena Sakai wrote: > On my postgres 8.1.1, I get a response > psql: FATAL: connection limit exceeded for non-superusers > 1) Is this to do with max_connections setting in the postgres > configuration file? (my setting is 100 (I think this is the > default).) Yep. > 2) how would I look at the "open/used" connections? select * from pg_stat_activity; > 3) should I try restarting postgres without changing the setting? Has to be restarted for change to take effect. > 4) what repercussion would there be if I increase this number to, > say, 200? (and would that be a good idea?) A little overhead, nothing bad. > 5) finally, what's the best fix? (Do I need to go to pgpool?) see pgbouncer -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/