need help to recover database

Lists: pgsql-general
From: Haroon Sayyad <harcheeze(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: need help to recover database
Date: 2006-06-15 04:58:36
Message-ID: 20060615045836.87096.qmail@web30502.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Dear Sir,
Please help us and guide us to solve following error while using postgres 8.3 version.
Error showing is

'invalid page header in block 102 of relation pg_proc'

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


From: Richard Huxton <dev(at)archonet(dot)com>
To: Haroon Sayyad <harcheeze(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: need help to recover database
Date: 2006-06-16 06:35:44
Message-ID: 44925140.5080303@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Haroon Sayyad wrote:
> Dear Sir, Please help us and guide us to solve following error while
> using postgres 8.3 version. Error showing is
>
> 'invalid page header in block 102 of relation pg_proc'

There is no PostgreSQL version 8.3 - please check again.

The error message suggests on-disk corruption. Have you had crashes? Do
you have backups readily available? What operating-system are you
running on?

--
Richard Huxton
Archonet Ltd