Re: Mediawiki 1.10 and PG 8.3 upgrade - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Mediawiki 1.10 and PG 8.3 upgrade
Date
Msg-id 7c7abb60b58170bc42f845a4ec53838c@biglumber.com
Whole thread Raw
In response to Re: Mediawiki 1.10 and PG 8.3 upgrade  (Oliver Kohll <oliver@gtwm.co.uk>)
List pgsql-general
-----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 dumped does not include the mwusers table, so it's
not entirely helpful.

I spoke too soon when I said earlier all one needs is php update.php.
There are some serious tsearch2 issues that prevent you from dumping
the old database and importing into the new version, even with the
tsearch2 compatibility stuff. I'm creating some workarounds, and
will report back. Doing a --data-only dump and creating the schema
anew from maintenance/postgres/tables.sql should work, although
not if you've made any schema changes, obviously.


- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200805311103
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkhBaX4ACgkQvJuQZxSWSsg2lgCfWn5bPrgZFfp+Tf/rZFlqSEIm
AB8AoKfl/ooepXLbjzh3ql4GGuk86MJT
=yQ9w
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: Oliver Kohll
Date:
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade
Next
From: "Ken Winter"
Date:
Subject: Converting empty input strings to Nulls