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: 1504012229.20080124015902@ural.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-admin by date

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