SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 05:24 PM
| ||||
| ||||
 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? ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-09-2008, 05:24 PM
| |||
| |||
| Re: 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/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
|
04-09-2008, 05:24 PM
| |||
| |||
| Re: 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 might find this useful. http://people.planetpostgresql.org/x...upgrading.html -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ |
|
04-09-2008, 05:24 PM
| |||
| |||
| Re: Tsearch2: upgrading from postgres 8.1.x to 8.2.x 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-09-2008, 05:24 PM
| ||||
| ||||
| 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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
