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

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