recover in single-user backend fails

From: "Wouter Sergeyssels" <Wouter(at)nucleus(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Subject: recover in single-user backend fails
Date: 2008-09-06 08:01:22
Message-ID: 18834F5BEC10824891FB8B22AC821A5A1DC6EC@nucleus-srv01.Nucleus.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

When doing a recover in a single-user backend we get the following
error:

$ postgres -D /var/lib/pgsql/data/ test

PANIC: block 24929 unfound

Aborted.

All this was the result of an unclean postmaster shutdown while running
a VACUUM in single-user backend.

PGVERSION=8.1.6

DB SIZE= +- 7GB

Thank you for the input!

Regards,

Wouter S.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-09-06 08:45:58 Re: large inserts and fsync
Previous Message Greg Smith 2008-09-06 07:49:05 Re: Oracle and Postgresql