Re: Which table stored in which file in PGDATA/base/[db-oid]

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Which table stored in which file in PGDATA/base/[db-oid]
Date: 2013-06-01 11:04:55
Message-ID: 20130601110455.GC30050@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jun 01, 2013 at 03:27:40PM +0430, Soroosh Sardari wrote:
> Yes, I have some files which is not in pg_class.relfilenode of any table or
> index.
> I want to know which table or index stored in such files.

That shouldn't happen. Are you sure you're looking in the right
database? Kan you list the filenames?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
-- Arthur Schopenhauer

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Victor Yegorov 2013-06-01 11:16:35 Re: Which table stored in which file in PGDATA/base/[db-oid]
Previous Message Soroosh Sardari 2013-06-01 10:57:40 Re: Which table stored in which file in PGDATA/base/[db-oid]