From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruno THOMAS <bthomas@alea.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_class corrupted ?
Date: Fri, 18 Jun 2004 11:52:22 -0400
Message-ID: <21057.1087573942@sss.pgh.pa.us> (raw)
In-Reply-To: <40D18921.3000609@alea.fr>
References: <40D18921.3000609@alea.fr>
Bruno THOMAS <bthomas@alea.fr> writes:
> My problem is that when I tried to make a dump of the copied DB for a
> new backup I've had the following error :
> pg_dump: query to obtain list of tables failed: ERROR: Relation
> pg_class does not have attribute 1
Reindexing pg_class might help. Read the reindex man page carefully,
because reindexing system tables is a tricky procedure before 7.4.
> PS: postresql version is 7.2.1
You like to live dangerously, eh? There are several known serious
bugs in 7.2.1. If you want to stay on the 7.2 series you should
at least update to 7.2.4 (or whatever the last of that series was).
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, bthomas@alea.fr
Subject: Re: pg_class corrupted ?
In-Reply-To: <21057.1087573942@sss.pgh.pa.us>
References: <40D18921.3000609@alea.fr> <21057.1087573942@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox