Re: Mediawiki 1.10 and PG 8.3 upgrade

Jon Lapham <lapham(at)jandr(dot)org> writes:
> My mediawiki pages are loading, but when I try to edit them, I get this
> error message:

> A database error has occurred Query: INSERT INTO pagecontent
> (old_id,old_text,old_flags) VALUES [snip] ERROR: text search
> configuration "default" does not exist CONTEXT: PL/pgSQL function
> "ts2_page_text" line 3 at assignment

There isn't a "default" configuration in 8.3, unless you make one named
that.

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

http://www.postgresql.org/docs/8.3/static/textsearch-migration.html
http://www.postgresql.org/docs/8.3/static/tsearch2.html

I haven't personally tried that procedure with MediaWiki, though.

regards, tom lane