pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
lost /pg_xlog
2+ messages / 2 participants
[nested] [flat]

* lost /pg_xlog
@ 2008-01-23 20:59  Alexander Vysokovskih <av@ural.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Alexander Vysokovskih @ 2008-01-23 20:59 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: lost /pg_xlog
@ 2008-01-23 22:48  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Alexander Vysokovskih <av@ural.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-01-23 22:48 UTC (permalink / raw)
  To: Alexander Vysokovskih <av@ural.org>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-01-23 22:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-23 20:59 lost /pg_xlog Alexander Vysokovskih <av@ural.org>
2008-01-23 22:48 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox