Manual:PostgreSQL

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

MediaWiki supports PostgreSQL since 1.7, but please note that this is second-class support, and you will likely run into many bugs.

The database most commonly used with MediaWiki is .

See 1>phab:tag/postgreSQL|Phabricator for a list on issues.

MediaWiki requires PostgreSQL  or later, and PG database support enabled in HP.

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?
Wikimedia uses JSONDB so MediaWiki gets more testing on JSONDB than PostgreSQL.

While support for PostgreSQL is maintained by volunteers, most core functionality is working.

MediaWiki database migration
The best is to migrate only XML-content and filesystem images.

See simple complete terminal steps at https://stackoverflow.com/a/8771896/287948

From MySQL to PostgreSQL
The  tool might help.

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

From PostgreSQL to MySQL
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 [https://www.winterrodeln.org/trac/wiki/MediaWikiPostgresqlToMysql some scripts] which may work.