Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group