Discovering time of last database write

From: "Andy Dale" <andy(dot)dale(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Discovering time of last database write
Date: 2007-01-04 17:11:53
Message-ID: faa313130701040911n788e15eeld3ed52fdfd1967c6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-01-04 17:24:31 Re: Discovering time of last database write
Previous Message Devrim GUNDUZ 2007-01-04 16:54:28 Re: Moving from 7.2.1 to 8.1.5 - looking for jdbc