pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: How to get the postmaster shut downtime dynamically and insert into a table? 2+ messages / 1 participants [nested] [flat]
* Re: How to get the postmaster shut downtime dynamically and insert into a table? @ 2018-06-04 11:26 pavan95 <pavan.postgresdba@gmail.com> 2018-06-06 08:53 ` Re: How to get the postmaster shut downtime dynamically and insert into a table? pavan95 <pavan.postgresdba@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: pavan95 @ 2018-06-04 11:26 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to get the postmaster shut downtime dynamically and insert into a table? 2018-06-04 11:26 Re: How to get the postmaster shut downtime dynamically and insert into a table? pavan95 <pavan.postgresdba@gmail.com> @ 2018-06-06 08:53 ` pavan95 <pavan.postgresdba@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: pavan95 @ 2018-06-06 08:53 UTC (permalink / raw) To: pgsql-admin Hi, Any possible ways? Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-06-06 08:53 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-06-04 11:26 Re: How to get the postmaster shut downtime dynamically and insert into a table? pavan95 <pavan.postgresdba@gmail.com> 2018-06-06 08:53 ` pavan95 <pavan.postgresdba@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox