Re: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"

Barry Clearwater wrote:
> LOG:  could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
> (log file 0, segment 1): No such file or directory
> LOG:  invalid primary checkpoint record
>
> Is there any way I can recreate a checkpoint record or resurrect any
> data from postgresql.  How important was the 0000000000000001 file ?

check pg_resetxlog from postgresql/bin

Regards,
Bjoern