From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: adey11@gmail.com
Cc: pgsql-admin@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] How to determine date / time of last postmaster restart
Date: Wed, 7 Sep 2005 15:29:53 -0400
Message-ID: <20050907192953.GJ5953@surnet.cl> (raw)
In-Reply-To: <20050907053844.GC60481@pervasive.com>
References: <1c66bda805090616596a199871@mail.gmail.com>
<22041.1126052554@sss.pgh.pa.us>
<20050907053844.GC60481@pervasive.com>
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, jnasby@pervasive.com, tgl@sss.pgh.pa.us, adey11@gmail.com, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] How to determine date / time of last postmaster restart
In-Reply-To: <20050907192953.GJ5953@surnet.cl>
References: <1c66bda805090616596a199871@mail.gmail.com> <22041.1126052554@sss.pgh.pa.us> <20050907053844.GC60481@pervasive.com> <20050907192953.GJ5953@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox