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

From Andy Dale
Subject Discovering time of last database write
Date
Msg-id faa313130701040911n788e15eeld3ed52fdfd1967c6@mail.gmail.com
Whole thread Raw
Responses Re: Discovering time of last database write  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
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.

Thanks in advance,

Andy

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: pg_dump question
Next
From: Scott Marlowe
Date:
Subject: Re: Discovering time of last database write