Manual:PostgreSQL

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
Deutsch • ‎English • ‎polski • ‎português • ‎português do Brasil • ‎русский • ‎中文 • ‎日本語

The purpose of this page is to collect information and experiences about running MediaWiki on PostgreSQL.

MediaWiki supports PostgreSQL since 1.7. See Phabricator for a list of issues. MediaWiki requires PostgreSQL 9.2 or later, and PG database support enabled in PHP.

Most of the common maintenance scripts work with PostgreSQL however some of the more obscure ones might have problems.

Is PostgreSQL a good choice for MediaWiki?[edit]

Wikimedia uses MariaDB so MediaWiki gets more testing on MariaDB than PostgreSQL. While support for PostgreSQL is maintained by volunteers, most core functionality is working.

MediaWiki database migration[edit]

From MySQL to PostgreSQL[edit]

The MWDumper tool might help.

There is also a mediawiki_mysql2postgres.pl perl script in maintenance/postgres, but there is uncertainty whether it works.

From PostgreSQL to MySQL[edit]

This is generally not recommended as converting from Postgres data types back to MySQL is not as simple an operation as the reverse.

There are however some scripts which may work.