ps auxwww | grep ^postgres
that should explain a little more...
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )
On 1/10/07, Ashish Karalkar <ashish_karalkar@xxxxxxxxx> wrote:
Hello All,
I am running PostgresSQL 8.2 on Redhat Linux 4.
When I look for the processes that are using postgres
using ps aux|more
I got lots of Idle processes with servers own IP
address. Can anybody please tell me why this is
happening.
Also there are multiple processes for my single
client(same IP) of which maximum are idle. are these
processes means connection or there is a single
connection starting many processes.
I am having max connection =200
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings