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

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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 05:38:44
Message-ID: 20050907053844.GC60481@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pradeepkumar, Pyatalo (IE10) 2005-09-07 06:10:24 Re: FW: Libpq - multibyte character support
Previous Message Miguel Higuera 2005-09-07 05:03:49 Re: FW: Libpq - multibyte character support

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2005-09-07 05:42:12 Re: Attention PL authors: want to be listed in template table?
Previous Message Jim C. Nasby 2005-09-07 05:31:01 Re: Remove xmin and cmin from frozen tuples