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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, adey11(at)gmail(dot)com, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] How to determine date / time of last postmaster restart
Date: 2005-09-07 19:29:53
Message-ID: 20050907192953.GJ5953@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-09-08 01:22:55 Re: [HACKERS] How to determine date / time of last postmaster restart
Previous Message Peter Eisentraut 2005-09-07 18:01:00 Re: How to determine date / time of last postmaster restart

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-09-07 19:38:32 Re: Attention PL authors: want to be listed in template table?
Previous Message Peter Eisentraut 2005-09-07 19:22:12 Re: Attention PL authors: want to be listed in template table?