Re: Getting process id of a connection?

Joshua D. Drake wrote:
> On Fri, 4 Jan 2008 14:59:47 -0800
> "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com> wrote:
>
>> Hi all,
>>
>> Is there a way to determine the pid of a database connection from
>> within that connection?
>>
>> As a hypothetical example, I would like to be able to do the
>> following:
>>
>> $ps x
>> PID TTY STAT TIME COMMAND
>> 11674 ? S 0:00 sshd: webbs(at)pts/1
>> 11675 pts/1 Ss 0:00 -bash
>> 11682 pts/1 T 0:00 psql
>> 11685 pts/1 R+ 0:00 ps x
>>
>> psql=# select CURRENT_PID;
>> 11682
>>
>> I want this so that I can log the psycopg2 connection pid, and kill it
>> to test reconnection code.
>
> postgres=# select procpid from pg_stat_activity;
> procpid
> - ---------
> 30851
> 17510
> 4496
> 20237
> 1305
> (5 rows)

I think he's looking for the pid of the client, not the server.

cww=# select procpid from pg_stat_activity;
procpid
---------
8902
(1 row)

8902 ? Ss 0:00 \_ postgres: cww cww 192.168.171.100(40424)
idle

Colin