Re: full text search in 8.3 - Mailing list pgsql-hackers

From Florian G. Pflug
Subject Re: full text search in 8.3
Date
Msg-id 470E2BBB.5000703@phlo.org
Whole thread Raw
In response to Re: full text search in 8.3  (andy <andy@squeakycode.net>)
Responses Re: full text search in 8.3
Re: full text search in 8.3
Re: full text search in 8.3
List pgsql-hackers
andy wrote:
> Is there any chance there is an easier way to backup/restore?  On one 
> hand, its not too bad, and it'll only be once (correct?).  Now that fts 
> is in core future backup/restores will work, right?  I think it's 
> analogous to telling someone they are updating from tsearch2 to 
> tsearch3, and it might be a little more painful than just a backup/restore.
> 
> On the other hand I think a backup/restore will pollute the new db with 
> a bunch of functions and types that wont ever be used, so it's so much 
> cleaner to build it by hand.
> 
> Are there other fts users that might have opinions on that?

I'm not really a tsearch user (just played with it a bit once). But I wondered 
if you are aware that you can prevent certain objects from being restored
quite easiy if you use pg_dump and pg_restore together with "custom format" 
(-Fc). There is some option to pg_restore that reads the dump, and ouputs a 
table of contents. You can then remove some entries from that list, and pass the 
modified list to pg_restore which will skip entries that do not show up on your 
modified list.

Maybe we could document some regexp, awk script, or similar that strips the 
tsearch stuff from such a table of contents?

regards, Florian Pflug


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timezone database changes
Next
From: Gregory Stark
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher