Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-06-04 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Rather than try to document my experiences here in an email thread, I created a wiki page to document the database upgrade process in general for MediaWiki. Please look it over and edit it as needed: http://www.mediawiki.org/wiki/Manual:Upgradi

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-31 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > If upgrading MediaWiki to a version that supports postgres 8.3, > another option could be to export from the old db as XML (using the > Special:Export page) You can also use the dumpBackup.php tool in the maintenance directory. The XML this d

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-31 Thread Oliver Kohll
If upgrading MediaWiki to a version that supports postgres 8.3, another option could be to export from the old db as XML (using the Special:Export page) then import once the new wiki's installed with a blank database - that's what I'm going to try, I've had problems upgrading MediaWiki data

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Also, a lot of the instructions do seem to be very postgres-oriented > (for example: hand editting of the pgdump output, etc), not much to do > on the mediawiki side of things. Other apps besides mediawiki seem to > have similar problems, or

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Christophe
You'll need to get a particular revision of MediaWiki that is PG 8.3 compatible: http://people.planetpostgresql.org/greg/index.php?/archives/123- MediaWiki-is-Postgres-8.3-compatible.html Once that's done, it works fine (at least for me). -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Jon Lapham
Tom Lane wrote: Jon Lapham <[EMAIL PROTECTED]> writes: 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 wit

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Jon Lapham
Joshua D. Drake wrote: Jon Lapham wrote: How are we, Joe PostgreSQL users on the street, supposed to know which instructions to follow? Have I (very possible) missed some official That would be a question for mediawiki people not PostgreSQL people. Okay, makes sense. It just seemed to me

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Joshua D. Drake
Jon Lapham wrote: Hello all, 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/p

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Tom Lane
Jon Lapham <[EMAIL PROTECTED]> 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 exis

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Stefan Kaltenbrunner
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

[GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

2008-05-30 Thread Jon Lapham
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. Possible useful info: OS: Fedora 9 Postgresql: PostgreSQL 8.3.1 on x86_64-redhat-linux-gnu Mediaiwiki: mediawiki-1.10.4-39.fc9.x86_64 My media