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

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/

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

When you say "reconfigure db" does this mean "recreate all your tsearch
indexes"?

Joshua D. Drake wrote:

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/

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 ?