Re: Data corruption (8.2.5 Windows XP)

From: Marc Schablewski <ms(at)clickware(dot)de>
To: regis(dot)boumera(at)steria(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data corruption (8.2.5 Windows XP)
Date: 2009-06-30 15:22:26
Message-ID: 4A4A2DB2.2080308@clickware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

regis(dot)boumera(at)steria(dot)com wrote:
> Is there a reason for this?
> Is there a way to "repair" the database?
>
>
I guess your primary key index got damaged. You could try to REINDEX the
table or DROP and recreate the index manually. Perhaps you should do a
backup of your data directory before reindexing your table, so someone
might be able to find out what happend to your database in the first place.

Marc

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rosko C.A. 2009-06-30 15:58:22 Help with installation please...
Previous Message Scott Ribe 2009-06-30 15:21:50 Re: Copying only incremental records to another DB..