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 4CE45D7D5C for ; Wed, 7 Sep 2005 15:01:19 -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 05951-07 for ; Wed, 7 Sep 2005 18:01:13 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id CC395D8206 for ; Wed, 7 Sep 2005 15:01:07 -0300 (ADT) Received: (qmail invoked by alias); 07 Sep 2005 18:01:07 -0000 Received: from dsl-082-083-237-238.arcor-ip.net (EHLO colt.pezone.net) [82.83.237.238] by mail.gmx.net (mp012) with SMTP; 07 Sep 2005 20:01:07 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: adey11@gmail.com Subject: Re: How to determine date / time of last postmaster restart Date: Wed, 7 Sep 2005 20:01:00 +0200 User-Agent: KMail/1.8.1 References: <1c66bda805090616596a199871@mail.gmail.com> In-Reply-To: <1c66bda805090616596a199871@mail.gmail.com> Cc: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200509072001.01559.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.044 required=5 tests=[AWL=-0.006, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/66 X-Sequence-Number: 18803 adey wrote: > Please let me know if there is a way to determine when the Postmaster > was last restarted? If you have configured your server log to contain timestamps, that is your best bet to look. In any case, the server log will tell when the last shutdown was, so you can at least narrow down the time frame. You can also use pg_controldata to check the time of last change to pg_control (which is changed when the server starts). -- Peter Eisentraut http://developer.postgresql.org/~petere/