Flutterby™! : upgrades

Next unread comment / Catchup all unread comments User Account Info | Logout | XML/Pilot/etc versions | Long version (with comments) | Weblog archives | Site Map | | Browse Topics


2008-02-29 23:33:34.576262+00 by Dan Lyke 3 comments

Should anyone ever be tempted to upgrade MediaWiki running on top of PostgreSQL without backing up first: Don't. Just sayin'.

[ related topics: Sports Databases ]

comments in ascending chronological order (reverse):

#Comment Re: made: 2008-03-03 13:38:08.63695+00 by: other_todd

Oh, my, you were trying to run MediaWiki on PostgreSQL in the first place? I admire your derring-do and your insanity.

#Comment Re: made: 2008-03-03 14:11:23.673708+00 by: Dan Lyke

Yeah, I was willing to muddle through with it at first to get things working, but after 3 major revs it was clear that it wasn't really a supported platform, so I switched to MySQL after this fiasco.

I also need to set up an "out" migration path, because next time this happens I want to be able to switch to something else...

#Comment Re: made: 2008-03-03 18:01:35.878019+00 by: other_todd

We were going to try to run MediaWiki on top of Oracle when we first installed it here, because we do everything else in Oracle and didn't want to deal with a separate MySQL installation.

But it became clear that even though MySQL's SQL implementation and Oracle's are not worlds different - I've ported DBI-dependent Perl scripts back and forth across flavors several times - MediaWiki really, really, REALLY wants to run with MySQL. Maybe one day I'll convert it, but at this point it has its own private MySQL and is happy.

The PostgreSQL project, I am given to understand, only had the longevity it did because one or two programmers in the MediaWiki universe nurtured it as their pet project. I get the impression that no one else involved in MediaWiki really cared much.