Re: Switching Database Engines

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Switching Database Engines
Date: 2011-04-26 18:24:18
Message-ID: BANLkTikVaikE6P-nA0oTeoQtC2junhDTYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 26, 2011 at 1:44 PM, Greg Sabino Mullane <greg(at)turnstep(dot)com> wrote:
> In general, yes. For your specific use case, it might be best to use
> MediaWiki's XML dump and restore. You could also use the conversion
> script that comes with MediaWiki, at:
>
> maintenance/postgres/mediawiki_mysql2postgres.pl
>
> It's a little old so I can't promise it will work with recent versions
> of MediaWiki, but should be enough to get you started testing.

Just to be clear and make sure I understand correctly, I can export
the Wiki info using the MediaWiki XML export tool (which I found) or I
can try to use the MediaWiki tool referenced as
'mediawiki_mysql2postgres.pl', right? I think from reading the
options, I should try the XML export 1st.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-04-26 18:26:54 Re: PG 9.0 - Default postgresql.conf?
Previous Message Andrew Sullivan 2011-04-26 18:17:41 Re: PG 9.0 - Default postgresql.conf?