| From: | Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| 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 12:15:02 |
| Message-ID: | CAFUsPDbQ8b_8tPAdPHdrOPXGdsBUN3P8OT4Z0GT+a2js6rMX6Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)svana(dot)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 | Content-Type | Size |
|---|---|---|
| newfile.pg | application/octet-stream | 943 bytes |
| filenode.pg | application/octet-stream | 918 bytes |
| newfile-filenode.pg | application/octet-stream | 84 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2013-06-01 13:51:36 | Re: detecting binary backup in progress |
| Previous Message | Andres Freund | 2013-06-01 11:27:42 | Re: Which table stored in which file in PGDATA/base/[db-oid] |