Re: How to tell how long server has been up?

Поиск
Список
Период
Сортировка
От Geoffrey
Тема Re: How to tell how long server has been up?
Дата
Msg-id 4668313F.8070106@3times25.net
обсуждение исходный текст
Ответ на How to tell how long server has been up?  ("Chris Hoover" <revoohc@gmail.com>)
Список pgsql-admin
Chris Hoover wrote:
> Maybe I'm blind (wouldn't be the first time), but I can't see a way to find
> out how long postgres has been running.  Is there a way to tell this from a
> query?  I am working with some of the stat views and would like to
> correlate
> them to how long the server has been running.

I can think of a couple of ways...

ps aux|grep postmaster

ls -l postmaster.pid

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: warm standby database on 8.0.4
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.3 and 8.4 feature list