X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DEB00D7E0A; Wed, 7 Sep 2005 16:29:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26878-01; Wed, 7 Sep 2005 19:28:57 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 1D4B7D6E3B; Wed, 7 Sep 2005 16:28:56 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 07 Sep 2005 15:29:57 -0400 X-IronPort-AV: i="3.96,177,1122868800"; d="scan'208"; a="5126872:sNHT28891152" Received: from alvh.no-ip.org (216.155.85.134) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4317C634000A6D01; Wed, 7 Sep 2005 15:28:57 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 7E926C2DC74; Wed, 7 Sep 2005 15:29:53 -0400 (CLT) Date: Wed, 7 Sep 2005 15:29:53 -0400 From: Alvaro Herrera To: "Jim C. Nasby" Cc: Tom Lane , adey11@gmail.com, pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] How to determine date / time of last postmaster restart Message-ID: <20050907192953.GJ5953@surnet.cl> Mail-Followup-To: "Jim C. Nasby" , Tom Lane , adey11@gmail.com, pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org References: <1c66bda805090616596a199871@mail.gmail.com> <22041.1126052554@sss.pgh.pa.us> <20050907053844.GC60481@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050907053844.GC60481@pervasive.com> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.317 required=5 tests=[AWL=-0.459, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200509/67 X-Sequence-Number: 18804 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"