I used oid2name to find the index files: 168807081 168807081.1 168807081.2 168807081.3 168807081.4 Now how do I run the od command to find the block in question? Thanks, Akash On 6/23/05, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Akash Garg <akash.garg@xxxxxxxxx> writes: > > I'll try running the od command -- I'm just a little confused on where > > I run it. I tried running od -x 41661 but that doesn't yield any > > results. I'm assuming I have to run this command on the actual index > > file itself -- how do I do this? > > See contrib/oid2name, or read the docs at > http://developer.postgresql.org/docs/postgres/storage.html > to learn how to figure out which file is the index. (In pre-8.0 PG, > ignore what those docs say about tablespaces, but the rest of the info > goes back a ways.) The short answer is you need the database's OID > from pg_database, and the index's relfilenode from pg_class. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
