On Thursday 06 April 2006 16:45, Jim Nasby wrote:
> On Apr 4, 2006, at 11:08 AM, Scott Marlowe wrote:
> > On Mon, 2006-04-03 at 06:36, Markus Wollny wrote:
> >> Hi
> >>
> >> pgsql-general-owner@postgresql.org wrote:
> >>> Has anyone put MediaWiki up using the current version of Postgresql?
> >>
Most of the code I have seen has been run against pg 8.0.x or 8.1.x; generally
pg isnt the problem in this equation.
> >> I have, although our Mediawiki installation is currently not openly
> >> accessible. Can't say that it went like a breeze, but the obstacles
> >> where more or less minor and writing a little custom auth-plugin
> >> wasn't
> >> really too hard either. If your question was just along the lines of
> >> "does it run", I can confirm that, yes, it does. I cannot say
> >> though how
> >> well it would stand up to high loads and if every query and index has
> >> been fully tweaked.
> >
I know a few people running postgresql based mediawiki installations and it
seems to hold up pretty nicely. These folks aren't running the same code you
would find at the core mediawiki project, but instead they are using
patched/modified code to get things working. A fairly runnable copy is the
0.0.3 release of wikipgedia, though it too needs a few security updates from
the core project. You could probably get the cvs code working again, though
it needs testing and probably some fixes.
> > Given that this page:
> >
> > http://www.mediawiki.org/wiki/Help:%24wgDBtype
> >
> > says:
> >
> > Use ""mysql"" for working code and ""PostgreSQL"" for development/
> > broken
> > code.
> >
> > I'd guess that PostgreSQL support is not quite at the same level as
> > MySQL just yet. :)
>
I think this is a fairly good summary of things:
http://lists.pgfoundry.org/pipermail/wikipedia-news/2006-February/000017.html
> If I'm not confusing wiki's (and I'm offline now, so I can't check),
> Mediawiki is pretty un-interested in supporting PostgreSQL (hard to
> imagine why, given that some of their folks are paid by MySQL AB), so
> a fork was created on pgFoundry. I believe it's called pgpedia.
>
> If I am confusing wiki's, I'm wondering if they'd be willing to
> accept patches to improve PostgreSQL support...
You are not. I dubbed the new code wikipgedia, it lives on the foundry, the
home page is at http://wikipedia.projects.postgresql.org/. We would love to
have some new contributors. I hope to give another go around at making the
code production ready, but it involves the properly shaped tuits, and I don't
have a database company paying me to work on it :-)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL