Re: Error after power failure

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Roberts Staltmanis <staltmanis(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error after power failure
Date: 2010-08-30 20:52:30
Message-ID: AANLkTi=UV8+_ZM_uz4FKBJy1vZvN1NHfOcm7ahPmsP7H@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

maybe this article helps to you

http://blog.endpoint.com/2010/06/tracking-down-database-corruption-with.html

Regards
Pavel Stehule

2010/8/30 Roberts Staltmanis <staltmanis(at)gmail(dot)com>:
> Hello!
> I accidentally unplugged my computer and after restarting it my postgresql
> gives me this error:
> ERROR: invalid page header in block 45 of relation base/16395/2608
>
> What does it mean and how can I fix my db?
> I don't have any backups and I'm not really good with databases in general(I
> use it for personal use and I'm not an IT specialist).
>
> It would be really good if someone could help me because that database is
> really important(even though I don't have a backup for it).
>
> Thanks,
> Robert
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yosef Haas 2010-08-30 20:53:48 Re: select query on Dates stored as varchar
Previous Message Jeff Davis 2010-08-30 20:50:35 Re: two different posgres t for Rails development?