Re: Putting index entries to XLog - Mailing list pgsql-general

From Simon Riggs
Subject Re: Putting index entries to XLog
Date
Msg-id 1267530447.20134.9712.camel@ebony
Whole thread Raw
In response to Putting index entries to XLog  (Carsten Kropf <ckropf2@fh-hof.de>)
List 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 by date:

Previous
From: Nilesh Govindarajan
Date:
Subject: Re: How to grant a user read-only access to a database?
Next
From: Simon Riggs
Date:
Subject: Re: custom index