Re: [HACKERS] How to determine date / time of last postmaster restart

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [HACKERS] How to determine date / time of last postmaster restart
Дата
Msg-id 20050907192953.GJ5953@surnet.cl
обсуждение исходный текст
Ответ на Re: [HACKERS] How to determine date / time of last postmaster restart  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: [HACKERS] How to determine date / time of last postmaster restart  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] How to determine date / time of last postmaster  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
On Wed, Sep 07, 2005 at 12:38:44AM -0500, Jim C. Nasby wrote:
> On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote:
> > PG 8.1 will have a function to return postmaster start time, but not
> > database reset time.  I wonder if this is misdefined --- if you are
> > trying to measure database uptime, the last reset would be more
> > appropriate to track.
>
> Is it too late to add a function that returns last reset time as well?
> That would cover all bases and force some less confusing naming.

This would be one more vote in favour of initdb before next beta.
(pltemplate being the other one.)  We should set a threshold in order to
be able to decide ...

--
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Use it up, wear it out, make it do, or do without"

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: How to determine date / time of last postmaster restart
Следующее
От: chandrasekare@sofil.co.jp
Дата:
Сообщение: Linking Oracle DB from postgresql