Re: How to get postmaster shut down time in postgres?

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Mon, Jun 4, 2018 at 9:44 AM, pavan95 <pavan.postgresdba@xxxxxxxxx> wrote:

Hi Adrian/Melvin,

Thanks for your prompt replies. Yeah, I'm aware of that way.

But my requirement is to get the server shutdown time whenever that event
occurs and insert into a table dynamically!! Is it possible?

The main reason for my requirement is to find the time swing between server
stop and start.

Thanks in advance.

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

>... my requirement is to get the server shutdown time whenever that event
>occurs and insert into a table dynamically!! Is it possible?

Since you have not stated your O/S, we cannot provide a specific solution. However, I can suggest that you use

a command line script to grab the time from the log and then write to a file. EG. grep / find

--

Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!