Does/Can PG store administrative statistics? 
Author Message
 Does/Can PG store administrative statistics?
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



Sat, 10 Jan 2004 06:37:54 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Building perl mods pg:PG or DBD:PG on non

2. Building perl mods pg:PG or DBD:PG on non-PostgreSQLable machines

3. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file

4. pgsql/src/interfaces/perl5 Pg.pm Pg.xs

5. Multiple PG Installations with DBD::Pg?

6. DBD::Pg vs Pg.pm

7. Installing DBD::Pg module without Pg Database server

8. pg_dump: PG 7.0 -> PG 7.2.1

9. Installing DBD::Pg module without Pg Database server

10. Performance: Perl-DBI vs. PG Stored Procedures

11. Storing images in PG?


 
Powered by phpBB® Forum Software