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

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

From
Rick Schumeyer
Date:
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?

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

From
"Joshua D. Drake"
Date:
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/


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

From
Richard Huxton
Date:
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 might find this useful.

http://people.planetpostgresql.org/xzilla/index.php?/archives/291-The-pain-that-is-tsearch2-8.1-8.2-upgrading.html

--
   Richard Huxton
   Archonet Ltd

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

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

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
>


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

From
"Joshua D. Drake"
Date:
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/


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

From
Philippe Amelant
Date:
Le mercredi 23 mai 2007 à 11:08 -0400, Rick Schumeyer a écrit :
> 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.
>

Are you using snowball stemmer ?

> Is there a procedure for this that someone can point me to?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq