From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Monnerie <michael.monnerie@it-management.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: duplicate primary index in bayes db from SpamAssassin
Date: Thu, 17 Apr 2008 20:15:23 -0400
Message-ID: <2174.1208477723@sss.pgh.pa.us> (raw)
In-Reply-To: <200804180120.25335@zmi.at>
References: <200804141757.21574@zmi.at>
<200804170945.51400@zmi.at>
<20473.1208446891@sss.pgh.pa.us>
<200804180120.25335@zmi.at>
Michael Monnerie <michael.monnerie@it-management.at> writes:
> On Donnerstag, 17. April 2008 Tom Lane wrote:
>> Before you zap the database, would you be willing to make the actual
>> database files (not a dump, but the stored files) available? I'd
>> be interested to take a closer look at that index.
> Yes, could you please give me the quick hint how to find out which
> SELECT I must do to find the correct directory to a database? I saw it
> once, but... many other things got stored in my brain in between, so I
> VACUUMed that information out ;-)
SELECT oid, datname FROM pg_database;
The stuff I need to look at is under $PGDATA/base/OID/.
Please also send the results of
SELECT relfilenode, relname FROM pg_class;
in the busted database --- that'll save trying to claw it out of
pg_class by hand.
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, michael.monnerie@it-management.at
Subject: Re: duplicate primary index in bayes db from SpamAssassin
In-Reply-To: <2174.1208477723@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