Topic on Project:Support desk

How can I use mwdumper with Postgresql command line

2
200.131.224.101 (talkcontribs)

I was importing a MediaWiki database using mwdumper with MySql. Now I need to do the same thing, but using Postgresql.

Basicly I get a archive in this link:

http://dumps.wikimedia.org/enwiki/20140903/

And I use mwdumper program to get informations and put in my database.

This is the database script:

https://git.wikimedia.org/blob/mediawiki%2Fcore.git/HEAD/maintenance%2Fpostgres%2Ftables.sql

I created the database through this sql, and now I need to use mwdumper to put data in my database. I saw many links about this, but only to do in MySql.

Anyone know how to do this import using Postgres, using command line?

88.130.71.88 (talkcontribs)

Honest answer? Don't do it.

Sure, you can use Postgres, but if you do, that means that you will have to deal with brokenness and bugs. MediaWiki's Postgres support is by far not as mature as its MySQL support. Instead of trying to make things work with Postgres somehow, you should better set up MySQL and use that.

With MySQL you'll be far better off.

Reply to "How can I use mwdumper with Postgresql command line"