| 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:55:20 |
| Message-ID: | cb7b2cc4-6d94-df86-74fe-462b187dd8f1@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Teja | 2018-06-04 13:56:32 | Re: How to get postmaster shut down time in postgres? |
| Previous Message | Melvin Davidson | 2018-06-04 13:52:26 | Re: How to get postmaster shut down time in postgres? |