pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlost /pg_xlog
2+ messages / 2 participants
[nested] [flat]
* lost /pg_xlog
@ 2008-01-23 20:59 Alexander Vysokovskih <av@ural.org>
2008-01-23 22:48 ` Re: lost /pg_xlog Tom Lane <tgl@sss.pgh.pa.us>
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 20:59 lost /pg_xlog Alexander Vysokovskih <av@ural.org>
@ 2008-01-23 22:48 ` Tom Lane <tgl@sss.pgh.pa.us>
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