Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 23A129FC8B0 for ; Thu, 25 Oct 2007 15:24:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 99556-05 for ; Thu, 25 Oct 2007 15:24:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id ADF069FA21B for ; Thu, 25 Oct 2007 15:24:10 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Il7NI-0006jl-RI for pgsql-admin@postgresql.org; Thu, 25 Oct 2007 11:24:08 -0700 Message-ID: <13413046.post@talk.nabble.com> Date: Thu, 25 Oct 2007 11:24:08 -0700 (PDT) From: smiley2211 To: pgsql-admin@postgresql.org Subject: Database Restore - time of last occurrence MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.195 tagged_above=0 required=5 tests=AWL=-0.132, BAYES_00=-2.599, DNS_FROM_OPENWHOIS=1.13, FORGED_YAHOO_RCVD=2.297, WHOIS_MYPRIVREG=1.499 X-Spam-Level: ** X-Archive-Number: 200710/256 X-Sequence-Number: 27170 Hello all, Is there a way to tell when was the LAST time a database was restored? I checked the pg_database system table but I'm not sure what 'datfrozenxid' means or if it means anything???? SELECT datname, age(datfrozenxid) FROM pg_database; Thanks...Michelle. -- View this message in context: http://www.nabble.com/Database-Restore---time-of-last-occurrence-tf4692718.html#a13413046 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.