On 2/3/21 4:08 PM, Tom Lane wrote: > Bharath Rupireddy <bharath.rupireddyforpostg...@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). >
Is the postmaster PID really sensitive? Users with OS access can just list the processes, and for users without OS access / privileges it's mostly useless, no? regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company