Getting process id of a connection?

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Getting process id of a connection?
Date: 2008-01-04 22:59:47
Message-ID: b11ea23c0801041459l508700adw768e38b13c8de184@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks!
-W

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2008-01-04 23:06:58 Re: Getting process id of a connection?
Previous Message Ken Winter 2008-01-04 22:29:53 Re: Problem with pg_dump?