|
PostgreSQL
»
PostgreSQL - admin
Database Restore - time of last occurrence
View:
Threaded
Chronologically
All Messages
New views
1 Messages —
Rating Filter:
0
1
2
3
4
5
Alert me
Database Restore - time of last occurrence
by smiley2211
:: Rate this Message:
Reply to Author
|
View Threaded
|
Show Only this Message
Hello all,
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;
Thanks...Michelle.
Free embeddable forum
powered by
Nabble
Forum Help