"Morris Goldstein" <morris.x.goldstein@gmail.com> writes:
> I looked at the pg_resetxlog documentation and have a question. Here
> is output from pg_resetxlog -n:
[ snipped to just the non-constant numbers ]
> Current log file ID: 0
> Next log file segment: 1
> Latest checkpoint's StartUpID: 12
> Latest checkpoint's NextXID: 536
> Latest checkpoint's NextOID: 17142
Ick. This looks *exactly* like what pg_control would contain
immediately after initdb, in a 7.4 database. I suppose that someone
tried an initdb as a recovery method, without understanding the
consequences.
> Is it safe to run pg_resetxlog without the -l argument?
No, or at least it will not improve your situation. All those numbers
need to be higher, probably a lot higher. See the advice in the
pg_resetxlog man page about deriving reasonable values.
regards, tom lane