Postgres Pro
Downloads
Home   >   mailing lists

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

From Soroosh Sardari
Subject Re: Which table stored in which file in PGDATA/base/[db-oid]
Date
Msg-id CAFUsPDbQ8b_8tPAdPHdrOPXGdsBUN3P8OT4Z0GT+a2js6rMX6Q@mail.gmail.com
Whole thread Raw
In response to Re: Which table stored in which file in PGDATA/base/[db-oid]  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Tree view
Yes, I'm sure.

Difference of filenodes and new files changed w.r.t my first mail, because I added a table.
I attached 3 files,
newfile.pg : list of numerical files in base/[db-oid], ls | grep '[[:digit:]]\>'
filenode.pg : select distinct relfilenode from pg_class
newfile-filenode.pg : Set of oids which exists in newfile.pg and does not in filenode.pg


On Sat, Jun 1, 2013 at 3:34 PM, Martijn van Oosterhout <kleptog@svana.org> wrote:
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,

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Which table stored in which file in PGDATA/base/[db-oid]
Next
From: Simon Riggs
Date:
Subject: Re: detecting binary backup in progress