Andrew Rawnsley <ronz@xxxxxxxxxxxxxxx> writes: > I have a idle database (idle = no writes for @12 hours, everything > committed, > full dump in between) that was shut down cleanly, then imaged to another > machine. Forgetting a certain flag in the rsync command, my symlinked > pg_xlog didn't make the trip, and I didn't notice until the originals > were gone. > (Oh, the embarrassment...) > I ran pg_resetxlog, and reindexed the system tables. Everything seems > fine. > Both documentation and chatter on the lists imply that I should be > suspect of the database. Given the particulars mentioned above > (idleness, clean shutdown, etc), would that be true in this case? If the database was in fact cleanly shut down before copying, you shouldn't have any problem. pg_xlog is only needed to reapply changes that hadn't made it to disk yet. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
