Akash Kodibail <akash(dot)kodibail(at)onmobile(dot)com> 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.
I recommend that you read this page closely before proceeding:
http://www.postgresql.org/docs/8.4/interactive/app-pgresetxlog.html
-Kevin