Thread: Tsearch2: upgrading from postgres 8.1.x to 8.2.x
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?
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: >> 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 >
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 ? > 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