Re: Discovering time of last database write - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Discovering time of last database write
Date
Msg-id 1167931470.3421.25.camel@state.g2switchworks.com
Whole thread Raw
In response to Discovering time of last database write  ("Andy Dale" <andy.dale@gmail.com>)
Responses Re: Discovering time of last database write  ("Andy Dale" <andy.dale@gmail.com>)
List pgsql-general
On Thu, 2007-01-04 at 11:11, Andy Dale wrote:
> Hi,
>
> I need to be able to determine the last time (and date) that a
> database was written to.  I know it could be possible just to check
> the last modified dates in the PGDATA directory, but i need to compare
> the last write time of 3 databases (connecting via JDBC).  Hopefully
> the last write date is contained somewhere in a system table
> (information schema) but i have no idea of the table(s) i would need
> to query.

Bad news, it's not generally stored.

Good news, it's not that hard to implement.

Perhaps if you give us the bigger picture we can make more logical
suggestions on how to accomplish it.

pgsql-general by date:

Previous
From: "Andy Dale"
Date:
Subject: Discovering time of last database write
Next
From: Richard Huxton
Date:
Subject: Re: pg_dump question