Skip site navigation (1) Skip section navigation (2)

Re: Duplicate values found when reindexing unique index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mason Hale" <masonhale(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Duplicate values found when reindexing unique index
Date: 2007-12-31 06:08:35
Message-ID: 23720.1199081315@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mason Hale" <masonhale(at)gmail(dot)com> writes:
> I have downloaded, compiled and installed pg_filedump -- but I am not sure
> how to determine which file I should have it dump. I am not very familiar
> with the postgres file structure. Can you please provide some guidance? How
> do I determine the correct file?

> I've determined the relation "entry" has an oid = 16838 -- but the
> /data/base/16830 directory contains 92 1GB files named 16838.[1-92]

In the first place, it's relfilenode not OID to look at --- these
are often the same but not always.

Once you've got past that, there are 131072 blocks per file segment,
so logical block 1508573 would translate to segment .11 block 66781.
pg_filedump is too stupid to do that arithmetic for you :-(

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Gregory StarkDate: 2007-12-31 06:12:19
Subject: Re: Duplicate values found when reindexing unique index
Previous:From: Mason HaleDate: 2007-12-31 05:22:06
Subject: Re: Duplicate values found when reindexing unique index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group