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

Поиск
Список
Период
Сортировка
От Soroosh Sardari
Тема Re: Which table stored in which file in PGDATA/base/[db-oid]
Дата
Msg-id CAFUsPDbQ8b_8tPAdPHdrOPXGdsBUN3P8OT4Z0GT+a2js6rMX6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Which table stored in which file in PGDATA/base/[db-oid]  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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@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,

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Which table stored in which file in PGDATA/base/[db-oid]
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: detecting binary backup in progress