Postgres Pro
Downloads
Home   >   mailing lists

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

From Melvin Davidson
Subject Re: How to get postmaster shut down time in postgres?
Date
Msg-id CANu8FiyxU2JBm9KNqPn=d=VJ_ZZOtKPA7rnLKKNRp=Gtf39h-Q@mail.gmail.com
Whole thread Raw
In response to Re: How to get postmaster shut down time in postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-general
Tree view


On Mon, Jun 4, 2018 at 9:44 AM, pavan95 <pavan.postgresdba@gmail.com> 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!

pgsql-general by date:

Previous
From: pavan95
Date:
Subject: Re: How to get postmaster shut down time in postgres?
Next
From: Adrian Klaver
Date:
Subject: Re: How to get postmaster shut down time in postgres?