Re: How to get the postmaster shut downtime dynamically and insert into a table?

Hi all,

In postgres pg_postmaster_start_time() function gives us the time when
postmaster was last restarted.

Similarly, My requirement is to get the time when the postmaster has stopped
and the duration it has taken for the start of the server.

AFAIK, the shutdown time is present in the log file alone. Is there any
function wherein which we can get the stop time of the postmaster.

My requirement is to dynamically store the shutdown time into a table
whenever postmaster shutdowns.

Any help in achieving this would be really great.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html