Re: Tsearch2: upgrading from postgres 8.1.x to 8.2.x

Rick Schumeyer wrote:
> When you say "reconfigure db" does this mean "recreate all your tsearch
> indexes"?

Well if you install tsearch2 ahead of time, the restore will take care
of that for you. What we typically do is this:

schema dump
rip out tsearch2
rip out all foreign keys, index creation etc...
take data dump

install tsearch2
restore skeleton schema
restore data dump
restore foreign keys, indexes etc...

I meant more along the lines of possibly having to add dictionaries etc...

Joshua D. Drake

> Joshua D. Drake wrote:
>> Rick Schumeyer wrote:
>>> I have a database running under pg 8.1.4 that uses tsearch2. I am
>>> upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
>>> install it in pg 8.2.4. This does not seem to work.
>>>
>>> Is there a procedure for this that someone can point me to?
>>
>> You uninstall tsearch2, dump/restore, install tsearch2, reconfigure db.
>>
>> Joshua D. Drake
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/