"Mark Steben" <msteben@xxxxxxxxxxxxxxx> writes: > The doc says to do an initdb and reload the data whenever you run > pg_resetxlog. Do you concur with that even if we are only resetting the OID > counter? The docs are thinking of the case where you are trying to recover from database corruption. If you just use it to change the OID counter after a clean shutdown, I don't see a problem. Not that it wouldn't be a good idea to take a backup first, just in case... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend