Jon Lapham wrote:
> Hello all,
>
> I'm sure I did something wrong during my upgrade of mediawiki from
> Postgresql 8.2 to 8.3. Any help on how to recover would be appreciated.
[...]
> I would like to say thanks to the people that put in so much time and
> effort in developing tsearch2 (and postgresql too), your work is greatly
> appreciated. However, I have never had a recent postgresql upgrade work
> seemlessly, and it is almost always due to issues with tsearch2. :(
yeah - upgrades with tsearch2 have always been a bit of a problem - this
is one of many reasons why tsearch2 got fully integrated into the
backend starting with 8.3.
>
> While searching the internet for magic recipes on how to perform these
> upgrades that involve tsearch2, I find long complex instruction sets
> detailing brain-numbingly complex operations (hand edit the schema!):
>
> http://julien.danjou.info/blog/index.php/post/2008/05/19/Upgrading-mediawiki-from-PostgreSQL-82-to-83
>
>
> Also, I have found this blog entry from Greg Mullane which makes it all
> seem so simple: (Note Tom Lane's comment, which seems to directly relate
> to the error message I am seeing).
>
> http://people.planetpostgresql.org/greg/index.php?/archives/123-MediaWiki-is-Postgres-8.3-compatible.html
>
>
> These are just a 2 examples, there are others. The one common thread
> shared by all the instructions are that they say different things. How
> are we, Joe PostgreSQL users on the street, supposed to know which
> instructions to follow? Have I (very possible) missed some official
> PostgreSQL instructions? How do we go about triaging tsearch2 problems?
http://www.postgresql.org/docs/8.3/static/textsearch-migration.html has
a some discussion - and also see the backwards compatibility module
provided in contrib/tsearch2.
Stefan