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:22:54
Message-ID: 4462191d-e3ee-bec1-3b69-e0f3c13f9c04@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2018-06-04 13:23:29 Re: How to get postmaster shut down time in postgres?
Previous Message pavan95 2018-06-04 13:17:30 How to get postmaster shut down time in postgres?