Re: pg_resetxlog question

Andrew Rawnsley <ronz(at)ravensfield(dot)com> 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