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

From: Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get postmaster shut down time in postgres?
Date: 2018-06-04 13:56:32
Message-ID: CACh9nsYFJuH4rGGcFz_Tiju6+z=sdO-=hCWNqPw0Wvm9KK0X_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you so much for your replies.😀

On Mon, Jun 4, 2018, 7:25 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-06-04 14:00:14 Re: How to get postmaster shut down time in postgres?
Previous Message Adrian Klaver 2018-06-04 13:55:20 Re: How to get postmaster shut down time in postgres?