How to map columns in pg_stat_activity to windows PID - Mailing list pgsql-admin

Hello,

Postgresql 8.3.2 on Windows server 2003 R2 standard

I have a client program connecting to postgresql
database.

The purpose is to find its session information in the
pg_stat_activity table.

But the PID value from the windows' task manager
doesn't equal to any value in the output of
select * from pg_stat_activity;

For example, the windows task manager shows PID = 2760
but the procpid column shows: 2820
(I idenfied it by the username/databasename/tcp port
number)

Appreciate your inputs!


__________________________________________________
赶快注册雅虎超大容量免费邮箱?
http://cn.mail.yahoo.com