To: Michael Monnerie <michael.monnerie@it-management.at>
cc: pgsql-admin@postgresql.org
Subject: Re: duplicate primary index in bayes db from SpamAssassin 
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>
Comments: In-reply-to Michael Monnerie <michael.monnerie@it-management.at>
	message dated "Fri, 18 Apr 2008 01:20:24 +0200"
Date: Thu, 17 Apr 2008 20:15:23 -0400
Message-ID: <2174.1208477723@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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? 狢'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