Skip site navigation (1) Skip section navigation (2)

Re: Mediawiki 1.10 and PG 8.3 upgrade

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 (view raw or flat)
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.


Responses

pgsql-general by date

Next:From: Greg Sabino MullaneDate: 2008-05-31 15:07:37
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade
Previous:From: dvsDate: 2008-05-31 08:29:32
Subject: Re: cannot use result of (insert .. returning)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group