From: | Oliver Kohll <oliver(at)gtwm(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Mediawiki 1.10 and PG 8.3 upgrade |
Date: | 2008-05-31 12:19:33 |
Message-ID: | B9CC2C1E-FC4A-439A-A369-E5F5E8374829@gtwm.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 databases in the past, possibly due to customised
installations. This should hopefully render any database issues
irrelevant.
You need to know the names of the pages to export, but could get those
with a simple query direct to the database like
SELECT pagetitlecolumn FROM tablewherepagetitlesarestored;
- see http://www.mediawiki.org/wiki/Manual:Database_layout
Regards
Oliver
On 30 May 2008, at 22:10, pgsql-general-owner(at)postgresql(dot)org wrote:
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2008-05-31 15:07:37 | Re: Mediawiki 1.10 and PG 8.3 upgrade |
Previous Message | dvs | 2008-05-31 08:29:32 | Re: cannot use result of (insert .. returning) |