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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to get postmaster shut down time in postgres?
Date: 2018-06-04 13:55:20
Message-ID: cb7b2cc4-6d94-df86-74fe-462b187dd8f1@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Teja 2018-06-04 13:56:32 Re: How to get postmaster shut down time in postgres?
Previous Message Melvin Davidson 2018-06-04 13:52:26 Re: How to get postmaster shut down time in postgres?