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

From Adrian Klaver
Subject Re: How to get postmaster shut down time in postgres?
Date
Msg-id cb7b2cc4-6d94-df86-74fe-462b187dd8f1@aklaver.com
Whole thread Raw
In response to Re: How to get postmaster shut down time in postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: How to get postmaster shut down time in postgres?  (Pavan Teja <pavan.postgresdba@gmail.com>)
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


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: How to get postmaster shut down time in postgres?
Next
From: Pavan Teja
Date:
Subject: Re: How to get postmaster shut down time in postgres?