Akash Kodibail <akash.kodibail@xxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin