Tom Lane escribió:
> When I've wanted to do that in the past, I've used pg_resetxlog to
> adjust a cluster's counters. It still requires some manual hacking
> though because pg_resetxlog isn't bright enough to create the new
> pg_clog files needed when you move the xid counter a long way.
> We could fix that, or we could make the backend more forgiving of
> not finding the initial clog segment present at startup ...
FWIW we already have some new code that creates segments when not found.
It's currently used in multixact, and the submitted "commit timestamp"
module uses it too.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services