Re: Connection Limit - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Connection Limit
Date
Msg-id 20070730215105.GB6839@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Connection Limit  ("Jon Horsman" <horshaq@gmail.com>)
List 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@crankycanuck.ca
The very definition of "news" is "something that hardly ever happens."        --Bruce Schneier


pgsql-sql by date:

Previous
From: "Jon Horsman"
Date:
Subject: Re: Connection Limit
Next
From: Andreas Joseph Krogh
Date:
Subject: Table-name as parameter to plpgsql