recover in single-user backend fails - Mailing list pgsql-general

From Wouter Sergeyssels
Subject recover in single-user backend fails
Date
Msg-id 18834F5BEC10824891FB8B22AC821A5A1DC6EC@nucleus-srv01.Nucleus.local
Whole thread Raw
Responses Re: recover in single-user backend fails  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Oracle and Postgresql
Next
From: Greg Smith
Date:
Subject: Re: large inserts and fsync