Manual:PostgreSQL

From MediaWiki.org
Jump to: navigation, search

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

MediaWiki supports Postgres since 1.7. See bugzilla:384 for a list of issues. MediaWiki requires Postgres 8.3 or later, and PG database support enabled in PHP.

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

Is PostgreSQL a good choice for MediaWiki?[edit | edit source]

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

MediaWiki database migration[edit | edit source]

From MySQL to PostgreSQL[edit | edit source]

The mwdumper tool might help.

There is also mediawiki_mysql2postgres.pl in maintainance/postgres but there is uncertainty whether it works.

From PostgreSQL to MySQL[edit | edit source]

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.

Databases Engines: MySQLOraclePostgreSQLSQLite
Technical documentation: Schema (tables) – API property associationsField prefixesPrimary key storage in other fieldsWikimedia extension tables
Configuration: SettingsSharing
Development: AccessOptimizationPolicyUpdaterExtension schema updatesPatch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist
Language: English  • Deutsch • 日本語 • polski • português • português do Brasil