Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the PID associated with a Perl DBI dbh? - Mailing list pgsql-general

From Joshua Tolley
Subject Re: How to get the PID associated with a Perl DBI dbh?
Date
Msg-id 20090312142713.GG24273@eddie
Whole thread Raw
In response to Re: How to get the PID associated with a Perl DBI dbh?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
On Thu, Mar 12, 2009 at 03:13:13PM +0100, A. Kretschmer wrote:
> In response to Kynn Jones :
> > Is there a reliable way to find out the (Unix) PID associated with a database
> > handle generated by Perl DBI's database connection?
>
> You can ask the pg_stat_activity - View, column procpid.

The query "select pg_backend_pid()" issued through that handle will also
return the PID.

- Josh / eggyknap
Attachment

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to get the PID associated with a Perl DBI dbh?
Next
From: Martin Gainty
Date:
Subject: Re: How to get the PID associated with a Perl DBI dbh?