Simplest solution would seem to be restore from backup taken before the crash
and corruption.
--
Nigel Andrews
On Wed, 11 Jun 2003, Bruno BAGUETTE wrote:
> re-Hello,
>
> First, a little rectification, it's PostgreSQL 6.5.2 and not 6.5.3 as I
> wrote in the last message...
>
> Second : I've tried doing a vacuumdb of the database but it don't
> changes anything... I'm still having the message "Couldn't find any
> tables, sequences or indices!". :-(
>
> It looks like the PostgreSQL system tables are corrupted...
>
> Any idea to fix that problem ?
>
> ---------------------------------------
> Bruno BAGUETTE - pgsql-ml@baguette.net
>
> > -----Message d'origine-----
> > De : Bruno BAGUETTE [mailto:pgsql-ml@baguette.net]
> > Envoyé : mercredi 11 juin 2003 10:34
> > À : 'pgsql-general@postgresql.org'
> > Objet : Couldn't find any tables, sequences or indices!
> >
> >
> > Hello,
> >
> > I use PostgreSQL 6.5.3 and it coredumped during the night... :-(
> >
> > This morning, I can't see the tables or anything in the
> > databases, when I do a \d in psql, I get the message
> > "Couldn't find any tables, sequences or indices!".
> >
> > But the file that contains the DB is NOT empty (this a
> > laaarge file). So I'm sure that the DB is not really empty...
> > But a pg_dump give me an empty dump file... :-(
> >
> > Do you have an idea to help me to fix that problem ?
> >
