Re: tsearch2 best practices - Mailing list pgsql-general

From Ian Barwick
Subject Re: tsearch2 best practices
Date
Msg-id 1d581afe0711190544y783f9186h60c091cbc7186d6e@mail.gmail.com
Whole thread Raw
In response to tsearch2 best practices  ("Mag Gam" <magawake@gmail.com>)
Responses Re: tsearch2 best practices  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-general
2007/11/18, Mag Gam <magawake@gmail.com>:
> Hi All,
>
> Planning to implement tsearch2 for my websitem and dbschema. I wanted to
> know if there is a "Best practices" guide I should be following. While
> reading about it, I noticed there were lot of 'gotchas' with this, such as
> back-up/restore, Slony 1 replication issues, etc..
>
> What do most people recommend for backup/restore solution: 1) Install
> tsearch 2)Alter tables for tsearch2, update trigger, 3) do work .. 4)
> uninstall tsearch2, 5)backup? Is that the right approach? Or something else?
>
> Also, when will tsearch2 part of core, instead of contrib?

tsearch2 has been integrated into the upcoming 8.3 release (currently beta).

--
http://sql-info.de/index.html

pgsql-general by date:

Previous
From: "Tom Allison"
Date:
Subject: IP addresses
Next
From: Mike Charnoky
Date:
Subject: convert custom datatype to array