Is there a way to tell when was the LAST time a database was restored? I
checked the pg_database system table but I'm not sure what 'datfrozenxid'
means or if it means anything????
SELECT datname, age(datfrozenxid) FROM pg_database;
View this message in context: http://www.nabble.com/Database-Restore---time-of-last-occurrence-tf4692718.html#a13413046
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
pgsql-admin by date
|Next:||From: smiley2211||Date: 2007-10-25 18:31:46|
|Subject: Postgresql New login - password expiration???|
|Previous:||From: Teodor Sigaev||Date: 2007-10-25 18:05:45|
|Subject: Re: Problem with PITR Past Particular WAL File|