Ron <ronljohnsonjr@xxxxxxxxx> writes: > Hi, > > v8.4 (Yes, it's archaic. Upgrade plan is in progress.) Please do! :-) > What queries should I run against the catalog tables to see whether or > not the cluster is healthy after reboot? Is the cluster confi'd to be at risk of corruption after crash.. such as full_page_write=off, fsync=off? Do your logs show any obvious sign of corruption, bad blocks etc? You may have little to worry about since Pg is very crash tolerant even old versions 8.4 and prior. I'd try vacuum and analyze whole cluster plus dumpall >/dev/null and check for errors there too. Any sort of corruption likely to cause application problems likely to show up in so doing. HTH > Thanks -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800
