Re: Last modification time of a database?

    Erik Jones wrote:

> These are all client databases at the web hosting company I work at.

> I can't go putting triggers on all of their tables.  I think I'll
just
> start taking snapshots of pertinent data from pg_stat_activity and
> after I've been collecting data for a while run a report of dbs that

> haven't seen connections in X long since what I'm really after is
> inactive databases.

Did you think about just setting log_connections to ON and grep'ing the
server logs?

Otherwise it looks like a use-case for ON CONNECT triggers,
unfortunately we don't have them yet.

The TODO list links that message:
http://archives.postgresql.org/pgsql-hackers/2008-03/msg00451.php


Best regards,

--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org