Re: Putting index entries to XLog

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Putting index entries to XLog
Дата
Msg-id 1267530447.20134.9712.camel@ebony
обсуждение исходный текст
Ответ на Putting index entries to XLog  (Carsten Kropf <ckropf2@fh-hof.de>)
Список pgsql-general
On Thu, 2010-02-25 at 12:41 +0100, Carsten Kropf wrote:

> I have encountered a problem while implementing an index structure. I don't have any access to the RM (I don't know,
howto set it up properly) using my index. However, when I don't have the situation of working with a temporary table, I
needto put entries using XLogInsert(...). The problem for me is, that based on the fact, that I don't have the access
tothe RM, I can't put proper entries to the xlog facility. How can I achieve that my index structure can be stored
properlyat least? 
> I'm getting lots of errors, when I just put a XLogRecPtr with data {1,1} as LSN of the page. On the other hand when
doingXLogInsert calls to work with the component properly I don't know which data to put in there. When I'm using some
kindof RM_ID (like RM_GIST_ID or something like that) I'm getting problems because I don't know which code to insert
there.I decided to take RM_GIST_ID and an invalid code (so it won't call any of the xlog gist implementations upon
recovery)which, however failed, too. Unfortunately my task is to implement a certain structure with PostgreSQL, so all
ofmy current work actually depend on this action. 
> I hope that somebody will be able to help me according to this issue.
> Thanks in advance

Each new index type requires a new rmgr to allow it to be recoverable.

The rmgr is not part of the index API, so it is not currently possible
to add a new index type *and* make it recoverable without editing the
server source code.

--
 Simon Riggs           www.2ndQuadrant.com


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

Предыдущее
От: Nilesh Govindarajan
Дата:
Сообщение: Re: How to grant a user read-only access to a database?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: custom index