From MediaWiki.org
Jump to: navigation, search
This page is a translated version of the page Manual:PostgreSQL and the translation is 38% complete.

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 obsługuje PostgreSQL od wersji 1.7. See task T2384 for a list of issues. MediaWiki requires PostgreSQL 9.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?[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.

Migracji bazy danych MediaWiki[edit | edit source]

Z MySQL do PostgreSQL[edit | edit source]

The MWDumperManual:MWDumper tool might help.

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

Z PostgreSQL do 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.

Bazy danychManual:Database layout Silniki: Podręcznik:MySQLManual:MySQLOracleManual:OraclePodręcznik:PostgreSQLManual:PostgreSQLSQLiteManual:SQLite
Dokumentacja techniczna: SchematyManual:Database layout (tabeleCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Konfiguracja: SettingsManual:Configuration_settings#Database_settingsUdostępnianieManual:Shared database
Rozwój: DostępManual:Database accessOptimizationDatabase optimizationZasadyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist