Can we have a new SQL callable function to get Postmaster PID?

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Can we have a new SQL callable function to get Postmaster PID?
Дата
Msg-id CALj2ACW7YB7_w0eHgpxEFfc8gcm_pUkQBKBXHS8-orQ3HPnTfw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can we have a new SQL callable function to get Postmaster PID?  ("Euler Taveira" <euler@eulerto.com>)
Re: Can we have a new SQL callable function to get Postmaster PID?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Can we have a new SQL callable function to get Postmaster PID?  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
Hi,

Can we have a new function, say pg_postgres_pid(), to return
postmaster PID similar to pg_backend_pid()? At times, it will be
difficult to use OS level commands to get the postmaster pid of a
backend to which it is connected. It's even worse if we have multiple
postgres server instances running on the same system. I'm not sure
whether it's safe to expose postmaster pid this way, but it will be
useful at least for debugging purposes on say Windows or other
non-Linux platforms where it's a bit difficult to get process id.
Users can also look at the postmaster.pid file to figure out what's
the current postmaster pid, if not using OS level commands, but having
a SQL callable function makes life easier.

The function can look like this:
Datum
pg_postgres_pid(PG_FUNCTION_ARGS)
{
    PG_RETURN_INT32(PostmasterPid);
}

Thoughts?

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax
Следующее
От: vignesh C
Дата:
Сообщение: Re: Printing backtrace of postgres processes