On Mon, Oct 10, 2011 at 2:59 PM, Kevin Grittner <[email protected]> wrote: > Akash Kodibail <[email protected]> wrote: > >> Can you please help me out in the options that might have to be >> set for pg_resetxlog. > > It should normally be able to calculate what it needs if you just > point it at the data directory. I would run it with the -n (no > operation) flag first, to see what it plans to do. If that looks > sane, run again without the -n switch.
But it uses pg_controldata to determine what it needs automagically. So... Since his pg_controldata is not the up to date one he's gonna have to figure out what number to give it. I have no clue how to do that at this point. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
