Re: lost /pg_xlog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Vysokovskih <av(at)ural(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: lost /pg_xlog
Date: 2008-01-23 22:48:41
Message-ID: 26740.1201128521@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alexander Vysokovskih <av(at)ural(dot)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

In response to

  • lost /pg_xlog at 2008-01-23 20:59:02 from Alexander Vysokovskih

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2008-01-24 18:31:55 8.3 Logging Question
Previous Message Alexander Vysokovskih 2008-01-23 20:59:02 lost /pg_xlog