I'd like to have statistics on when my database was last backed up or vacuumed. Currently, I'm implementing this by using simple shell scripts that write a date stamp to ascii files. I was wondering whether this is or could be a feature added to Postgres? For example, could one of the pg_* tables contain the fields 'last_vacuum' or 'last_backup' (which would be updated every time the vacuum or pg_dump command was executed). Perhaps something like this exists that I'm unaware of? -Tony ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
