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

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: How to get postmaster shut down time in postgres?
Дата
Msg-id CANu8FiyxU2JBm9KNqPn=d=VJ_ZZOtKPA7rnLKKNRp=Gtf39h-Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to get postmaster shut down time in postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
Список pgsql-general
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: pavan95
Дата:
Сообщение: Re: How to get postmaster shut down time in postgres?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to get postmaster shut down time in postgres?