[ADMIN] Database Restore - time of last occurrence

2007-10-25 Thread smiley2211
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. -- View this message in contex

[ADMIN] Database Restore

2000-01-31 Thread Serge Sozonoff
Hello all, I have the following scenario. 1 Linux server (Server A) running Postgres compiled with the standard BLCKSZE of 8Kb 1 Linux server (Server B) running Postgres compiled with a 32kb BLCKSZE in the include/config.h file. A 90 Table database sitting on server A that needs to get to Ser