How to repair a corrupt database

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to repair a corrupt database
Date: 2002-04-18 10:17:59
Message-ID: 200204181018.g3IAI2B06761@server9.telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Sometimes when i import a psql dump, i found out that the original dabases
had fault values (NULL value where NULL is not allowd, dubble primary keys
...).
This cost me a lot of time to correct everything.

So, how kan i repair a postgres database before i make an export ?

Regards,
Ferdinand

Browse pgsql-admin by date

  From Date Subject
Next Message Morten Sickel 2002-04-18 12:49:39 Re: problem in module Pg with Apache, Perl and SSL
Previous Message Rommel B. Abaya 2002-04-18 07:40:38 Database mirroring