Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we have a new SQL callable function to get Postmaster PID? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Can we have a new SQL callable function to get Postmaster PID?
Date
Msg-id 3905772.1612364917@sss.pgh.pa.us
Whole thread Raw
In response to Can we have a new SQL callable function to get Postmaster PID?  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: Can we have a new SQL callable function to get Postmaster PID?
List pgsql-hackers
Tree view 
Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> writes:
> Can we have a new function, say pg_postgres_pid(), to return
> postmaster PID similar to pg_backend_pid()?

I'm disinclined to think that this is a good idea from a security
perspective.  Maybe if it's superuser-only it'd be ok (since a
superuser would have other routes to discovering the value anyway).

            regards, tom lane

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Improve new hash partition bound check error messages
Next
From: Peter Eisentraut
Date:
Subject: Re: Prevent printing "next step instructions" in initdb and pg_upgrade