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 ?
>
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
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
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 us
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
