Re: [HACKERS] How to determine date / time of last postmaster restart - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: [HACKERS] How to determine date / time of last postmaster restart
Date
Msg-id 20050907192953.GJ5953@surnet.cl
Whole thread Raw
In response to Re: [HACKERS] How to determine date / time of last postmaster restart  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: [HACKERS] How to determine date / time of last postmaster restart
Re: [HACKERS] How to determine date / time of last postmaster
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: How to determine date / time of last postmaster restart
Next
From: chandrasekare@sofil.co.jp
Date:
Subject: Linking Oracle DB from postgresql