Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 338109FB293
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 30 Jul 2007 18:41:57 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 27150-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 30 Jul 2007 18:41:50 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from nz-out-0506.google.com (nz-out-0506.google.com
 [64.233.162.226])
	by postgresql.org (Postfix) with ESMTP id 77E3A9FB869
	for <pgsql-sql@postgresql.org>; Mon, 30 Jul 2007 18:41:53 -0300 (ADT)
Received: by nz-out-0506.google.com with SMTP id l8so969280nzf
	for <pgsql-sql@postgresql.org>; Mon, 30 Jul 2007 14:41:52 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=aLz1Sykqr2mXJCBoeTqpFhUU8S15FioLS0wgF6s7bJcbDfMvYck8eXOs+ls4xPTDd7AAOqNpb7kPLPTOk3EsjLF1GFE3RoYmdaZLRzXwlxoHhV1wlLys1DpCoa/ywKNJgiIZ8A/YFBSJoR0pkOObzGx2QEYHWe6BTtZN1o02gHc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=p78hpPta9GYAbCjlkqKY8zAWKxulssMiYX4anKBlMChpPnv1Poqd8xgAJNp/+8k2zuOzh+IN/2hrfR8A8yEpCF7n0wsCwNP/aj5lms1LEMTiJXfv/TjG/QPuv0VLNzS9Vi3ZthKqtesjXwkfFJ2T5Ko8ew93uC4BC9BfUHamJIY=
Received: by 10.115.23.12 with SMTP id a12mr6008847waj.1185831711302;
	Mon, 30 Jul 2007 14:41:51 -0700 (PDT)
Received: by 10.114.183.4 with HTTP; Mon, 30 Jul 2007 14:41:51 -0700 (PDT)
Message-ID: <4f4c2a010707301441h52763a42hc311fadad573e43a@mail.gmail.com>
Date: Mon, 30 Jul 2007 17:41:51 -0400
From: "Jon Horsman" <horshaq@gmail.com>
To: "sql pgsql" <pgsql-sql@postgresql.org>
Subject: Re: Connection Limit
In-Reply-To: <4f4c2a010707301429s76fb80abnf7c4a50c304647b7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4f4c2a010707301429s76fb80abnf7c4a50c304647b7@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/186
X-Sequence-Number: 28921

I have another related question

when running ps -fax i see the following
<snip>
 7476 ?        S      0:00  |       \_ postgres: mobileuser
mobileextension [local] idle
 8046 ?        S      0:00  |       \_ postgres: mobileuser
mobileextension 127.0.0.1 idle
<snip>

I have a few processes that are running with host = 127.0.0.1 and then
about 90% of all the processes are running as [local].  What does
[local] mean, since in fact 127.0.0.1 is obviously local, how do they
differ?

Thanks,

Jon.

On 7/30/07, Jon Horsman <horshaq@gmail.com> wrote:
> Hello,
>
> I have a server running postgres 7.4.13 and am starting to see errors
> "FATAL:  connection limit exceeded for non-superusers".
>
> I'm not sure which one of my applications are hogging all of the
> connections, is there a way debug this somehow?
>
> Thanks,
>
> Jon.
>