Postgres Pro
Downloads
Home   >   mailing lists

Re: lost /pg_xlog - Mailing list pgsql-admin

From Tom Lane
Subject Re: lost /pg_xlog
Date
Msg-id 26740.1201128521@sss.pgh.pa.us
Whole thread Raw
In response to lost /pg_xlog  (Alexander Vysokovskih <av@ural.org>)
List pgsql-admin
Tree view 
Alexander Vysokovskih <av@ural.org> writes:
> ---
> LOG:  could not open file "pg_xlog/000000030000000100000058" (log file 1, segment 88): No such file or directory
> LOG:  invalid primary checkpoint record
> ---
> before that happened postgres was shutdown normally.

If so, pg_resetxlog will get you out of this.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alexander Vysokovskih
Date:
Subject: lost /pg_xlog
Next
From: "Chris Hoover"
Date:
Subject: 8.3 Logging Question