Re: Discovering time of last database write

Hi,

Sorry for the slight delay in my response.

I am using 3 PostgreSQL databases and writing to them using an SQL proxy.
These databases have a high write volume. On rebooting all 3 servers for
OS/Software updates, i would like to figure out which was the last written
to DB (this is assuming the DB/Servers are not all taken down at the same
time), the times are kept in sync with NTP.

I imagine it is possible to get this behaviour with after triggers, but this
means i have to attach the same trigger to each table ??

Thanks,

Andy

On 04/01/07, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
>
> 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.
>