Re: corrupted table postgresql 8.3 - Mailing list pgsql-general

From Matteo Sgalaberni
Subject Re: corrupted table postgresql 8.3
Date
Msg-id d02e4d08-3e68-447c-af9f-1d2f7f54dcf8@zimbra1.ovus.it
Whole thread Raw
In response to Re: corrupted table postgresql 8.3  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
----- Original Message -----
> I mostly agree, but it's possible you got hit by a fixed bug.
I'm lucky ;)

someone know how I can correct the catalog and drop the old/renamed table?

Or probably is simpler:
- pg_dump database
- DROP database
- CREATE DATABASE
- psql database < dump

Or do I need to destroy and init the whole pg cluster?

I would like to be pretty sure of what can happen so I can plan the maintenance window...

Thanks for any hint!

Matteo

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: corrupted table postgresql 8.3
Next
From: Carlos Mennens
Date:
Subject: Automated Backup Script Help (Linux)