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: [EMAIL PROTECTED]/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. Thanks! -W ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
