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 4462191d-e3ee-bec1-3b69-e0f3c13f9c04@aklaver.com
Whole thread Raw
In response to How to get postmaster shut down time in postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-general
On 06/04/2018 06:17 AM, pavan95 wrote:
> Hi all,
> 
> Is there any way to get postmaster(postgres database) shutdown time?  Please
> help!!

Assuming you have the Postgres logging turned on it will be in the log:

The log when the server was shutdown:

2018-06-03 21:11:41.739 PDT-0LOG:  database system is shut down

The log when it was next started up:

2018-06-04 05:46:33.118 PDT-0LOG:  database system was shut down at
2018-06-03 21:11:41 PDT

> 
> 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: pavan95
Date:
Subject: How to get postmaster shut down time in postgres?
Next
From: Melvin Davidson
Date:
Subject: Re: How to get postmaster shut down time in postgres?