Re: Connection Limit

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Connection Limit
Date: 2007-07-30 21:51:05
Message-ID: 20070730215105.GB6839@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jul 30, 2007 at 05:41:51PM -0400, Jon Horsman wrote:
>
> 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?

I _believe_ [local] means UNIX domain socket. As to your other
question, either ps or pg_stat_activity is your friend.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The very definition of "news" is "something that hardly ever happens."
--Bruce Schneier

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2007-07-30 22:20:07 Re: Connection Limit
Previous Message Jon Horsman 2007-07-30 21:41:51 Re: Connection Limit