How to map columns in pg_stat_activity to windows PID

Поиск
Список
Период
Сортировка
От chen shan
Тема How to map columns in pg_stat_activity to windows PID
Дата
Msg-id 241408.97564.qm@web32106.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: How to map columns in pg_stat_activity to windows PID
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Updating a very large table
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Updating a very large table