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

lost /pg_xlog

From: Alexander Vysokovskih <av(at)ural(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: lost /pg_xlog
Date: 2008-01-23 20:59:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi there,

i have a situation on my sandbox:
pg_xlog directory of cluster was gone at stopped postgres. it was on another disk
which has broken. in this situation postgres falling to .core at startup with messages:
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.

i so understand that database is consistent, no? why we couldn't start?

Alexander Vysokovskih


pgsql-admin by date

Next:From: Tom LaneDate: 2008-01-23 22:48:41
Subject: Re: lost /pg_xlog
Previous:From: Tom LaneDate: 2008-01-23 20:56:58
Subject: Re: no entry on pg_database for a live database

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