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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux