This page is a translated version of the page Manual:PostgreSQL and the translation is 28% complete.

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 may likely run into some bugs. The database most commonly used with MediaWiki is MySQL . See Phabricator for a list of issues. MediaWiki requires PostgreSQL 10.0 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.

Czy PostgreSQL to dobry wybór dla MediaWiki?

Wikimedia uses MariaDB so MediaWiki gets more testing on MariaDB than PostgreSQL. Support for PostgreSQL is maintained by volunteers. Most core functionality is working.

Migracji bazy danych MediaWiki

The best is to migrate only XML-content and filesystem images. See simple complete terminal steps at https://stackoverflow.com/questions/8771896

Z MySQL do PostgreSQL

dumpBackup.php and importDump.php could be used for this.

Z PostgreSQL do 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, some scripts which may work.