Re: How to get postmaster shut down time in postgres? - Mailing list pgsql-general

On 06/04/2018 06:44 AM, pavan95 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?

A quick scan shows no built in function to do this. Looks like you will
need to parse the log file.

>
> 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
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com