Page MenuHomePhabricator
Projects PostgreSQL

PostgreSQLTag
ActivePublic
Watch Project

Members (4)

Watchers (6)

Details

Description

Issues related to supporting the use of the PostgreSQL database back-end for MediaWiki.

Recent Activity
View All

Wed, Dec 3

aaron removed the point value for T381908: Using SelectQueryBuilder::addJoin() with a string table reference and a null alias, combined with forUpdate(), fails in Postgres.
Wed, Dec 3, 11:49 PM · PostgreSQL, MW-1.44-release, MW-1.43-release, MW-Interfaces-Team, MediaWiki-libs-Rdbms
aaron set the point value for T381908: Using SelectQueryBuilder::addJoin() with a string table reference and a null alias, combined with forUpdate(), fails in Postgres to 0.5.
Wed, Dec 3, 11:49 PM · PostgreSQL, MW-1.44-release, MW-1.43-release, MW-Interfaces-Team, MediaWiki-libs-Rdbms

Tue, Dec 2

gerritbot added a project to T309096: "ERROR: column "u.user_id" must appear in the GROUP BY clause" with postgres v 14.2-1.pgdg110+1: Patch-For-Review.
Tue, Dec 2, 10:19 PM · Patch-For-Review, PostgreSQL, ContributionScores
gerritbot added a comment to T309096: "ERROR: column "u.user_id" must appear in the GROUP BY clause" with postgres v 14.2-1.pgdg110+1.

Change #1214165 had a related patch set uploaded (by Yaron Koren; author: Edward Chernenko):

[mediawiki/extensions/ContributionScores@REL1_43] Update for MediaWiki 1.43

https://gerrit.wikimedia.org/r/1214165

Tue, Dec 2, 10:18 PM · Patch-For-Review, PostgreSQL, ContributionScores

Mon, Dec 1

Maintenance_bot removed a project from T309096: "ERROR: column "u.user_id" must appear in the GROUP BY clause" with postgres v 14.2-1.pgdg110+1: Patch-For-Review.
Mon, Dec 1, 3:32 PM · Patch-For-Review, PostgreSQL, ContributionScores
gerritbot added a comment to T309096: "ERROR: column "u.user_id" must appear in the GROUP BY clause" with postgres v 14.2-1.pgdg110+1.

Change #1108514 merged by jenkins-bot:

[mediawiki/extensions/ContributionScores@master] Update for MediaWiki 1.43

https://gerrit.wikimedia.org/r/1108514

Mon, Dec 1, 2:54 PM · Patch-For-Review, PostgreSQL, ContributionScores

Nov 18 2025

A_smart_kitten closed T345793: Broken protect history link causing database errors for PostgreSQL backend as Resolved.

Brilliant, thanks @Atieno & @ABreault-WMF :)
I believe that's now everything that's left to do on this ticket; so boldly re-resolving.

Nov 18 2025, 6:20 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
ABreault-WMF added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.
In T345793#11377298, @A_smart_kitten wrote:

https://gerrit.wikimedia.org/r/c/1203855 has been merged (which I assume should hopefully remove the train-blocker for -wmf.3). To confirm, should that patch be backported to REL1_45?

Nov 18 2025, 5:26 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL

Nov 16 2025

A_smart_kitten added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

https://gerrit.wikimedia.org/r/c/1203855 has been merged (which I assume should hopefully remove the train-blocker for -wmf.3). To confirm, should that patch be backported to REL1_45?

Nov 16 2025, 4:36 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
Pppery removed a project from T26607: compressOld.php does not work on Postgres (gzip binary causes syntax error): MediaWiki-Maintenance-system.
Nov 16 2025, 2:58 AM · MediaWiki-Core-Revision-backend, PostgreSQL
Pppery removed a project from T359510: TypeError using runJobs.php with PostgreSQL: MediaWiki-Maintenance-system.
Nov 16 2025, 2:49 AM · MediaWiki-Core-JobQueue, MW-1.41-release, PostgreSQL
Pppery removed a project from T374044: "namespace_title still exists" warning on upgrading to 1.42: MediaWiki-Maintenance-system.
Nov 16 2025, 2:48 AM · MediaWiki-Installer, PostgreSQL

Nov 12 2025

Samwalton9-WMF moved T406676: RecentChanges with multiple change tags gives SQL error on PostgreSQL or strict mode from Maintenance priorities to Triaged on the Moderator-Tools-Team board.
Nov 12 2025, 4:56 PM · PostgreSQL, MediaWiki-Recent-changes, Moderator-Tools-Team
A_smart_kitten added a project to T345793: Broken protect history link causing database errors for PostgreSQL backend: MW-1.45-release.
Nov 12 2025, 11:01 AM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
Aklapper added a parent task for T345793: Broken protect history link causing database errors for PostgreSQL backend: T408273: 1.46.0-wmf.3 deployment blockers.
Nov 12 2025, 10:39 AM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
Aklapper reopened T345793: Broken protect history link causing database errors for PostgreSQL backend as "Open".

Reverted https://gerrit.wikimedia.org/r/q/aaf418b3c8ac1990308cd149b8f6485740c496f6 via https://gerrit.wikimedia.org/r/c/mediawiki/core/+/1204258 in the wmf.2 branch only by Ladsgroup, thus resolving T409831, reopening T345793, and marking T345793 as a wmf.3 blocker.

Nov 12 2025, 10:39 AM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL

Nov 11 2025

Aklapper added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

This change created a regression in T409831 which currently blocks the deployment train.

Nov 11 2025, 3:02 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL

Nov 10 2025

Pppery removed a project from T87542: Social Tools Postgres support: Patch-For-Review.
Nov 10 2025, 5:08 AM · PostgreSQL, Social-Tools

Nov 5 2025

Maintenance_bot removed a project from T345793: Broken protect history link causing database errors for PostgreSQL backend: Patch-For-Review.
Nov 5 2025, 3:32 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
ReleaseTaggerBot added a project to T345793: Broken protect history link causing database errors for PostgreSQL backend: MW-1.45-notes.
Nov 5 2025, 3:00 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1202129 merged by jenkins-bot:

[mediawiki/core@REL1_45] pagers: Make history pager work with Postgres

https://gerrit.wikimedia.org/r/1202129

Nov 5 2025, 2:32 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1202130 abandoned by Ammarpad:

[mediawiki/core@REL1_44] pagers: Make history pager work with Postgres

Reason:

IndexPager::getOffset exists only in >= 1.45

https://gerrit.wikimedia.org/r/1202130

Nov 5 2025, 2:12 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1202132 abandoned by Ammarpad:

[mediawiki/core@REL1_43] pagers: Make history pager work with Postgres

Reason:

IndexPager::getOffset exists only in >= 1.45

https://gerrit.wikimedia.org/r/1202132

Nov 5 2025, 2:12 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1202132 had a related patch set uploaded (by Ammarpad; author: Ammarpad):

[mediawiki/core@REL1_43] pagers: Make history pager work with Postgres

https://gerrit.wikimedia.org/r/1202132

Nov 5 2025, 1:43 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1202130 had a related patch set uploaded (by Ammarpad; author: Ammarpad):

[mediawiki/core@REL1_44] pagers: Make history pager work with Postgres

https://gerrit.wikimedia.org/r/1202130

Nov 5 2025, 1:42 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a project to T345793: Broken protect history link causing database errors for PostgreSQL backend: Patch-For-Review.
Nov 5 2025, 1:41 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1202129 had a related patch set uploaded (by Ammarpad; author: Ammarpad):

[mediawiki/core@REL1_45] pagers: Make history pager work with Postgres

https://gerrit.wikimedia.org/r/1202129

Nov 5 2025, 1:41 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
Maintenance_bot removed a project from T345793: Broken protect history link causing database errors for PostgreSQL backend: Patch-For-Review.
Nov 5 2025, 1:31 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
ReleaseTaggerBot added a project to T345793: Broken protect history link causing database errors for PostgreSQL backend: MW-1.46-notes (1.46.0-wmf.2; 2025-11-12).
Nov 5 2025, 1:01 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
Ammarpad closed T345793: Broken protect history link causing database errors for PostgreSQL backend as Resolved.
Nov 5 2025, 12:50 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1200672 merged by jenkins-bot:

[mediawiki/core@master] pagers: Make history pager work with Postgres

https://gerrit.wikimedia.org/r/1200672

Nov 5 2025, 12:37 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL

Nov 4 2025

herron added a comment to T374839: Port postgresql replication check to Prometheus/Alertmanager.

I've upgraded the prometheus postgres exporters across the fleet to the version from trixie which is capable of replica monitoring. I also gave prometheus pg_monitor privileges where called for by the updated exporter. Next will be sorting out replication alerts using the updated metrics.

Nov 4 2025, 6:45 PM · PostgreSQL, Observability-Alerting

Nov 2 2025

gerritbot added a project to T345793: Broken protect history link causing database errors for PostgreSQL backend: Patch-For-Review.
Nov 2 2025, 8:59 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL
gerritbot added a comment to T345793: Broken protect history link causing database errors for PostgreSQL backend.

Change #1200672 had a related patch set uploaded (by Ammarpad; author: Ammarpad):

[mediawiki/core@master] pagers: Make history pager work with Postgres

https://gerrit.wikimedia.org/r/1200672

Nov 2 2025, 8:59 PM · MW-1.45-release, MW-1.45-notes, MW-1.46-notes (1.46.0-wmf.2; 2025-11-12), MediaWiki-libs-Rdbms, PostgreSQL

Oct 28 2025

tappof assigned T374839: Port postgresql replication check to Prometheus/Alertmanager to herron.
Oct 28 2025, 11:14 AM · PostgreSQL, Observability-Alerting

Oct 22 2025

Leduardomoreira added a comment to T402690: Upgrading from 1.39.4 to 1.43.3 leads to drop index pl_namespace error.

@joernc_unibi I asked the developers about the database choice, because I read that line you quoted. I wanted their opinion if it worths migrating from PG to MariaDB since we have these problems with postgresql DB scripts.
I will study a possible migration to MariaDB, because it is time consuming try to fix things that are only broken on PG scripts. It is tiny problems like droping a collumn or an index that should exists and brokes the upgrade sequence. Even though it is tiny problems, we (the final user) dont have the impact of bypassing these drops.

Oct 22 2025, 2:43 PM · PostgreSQL, MediaWiki-Installer, MW-1.43-release
joernc_unibi added a comment to T402690: Upgrading from 1.39.4 to 1.43.3 leads to drop index pl_namespace error.

@saper Sorry, I don't have backups from the time before I upgraded all Wikis to 1.39, that was 2023. At the moment my test environment has only the latest version and I am upgrading my test Wikis before the productive ones. I am considering installing the old releases in my test environment so that I can actually test these upgrade chains. If e.g. these older releases are compatible with a recent PostgreSQL database, though.

Oct 22 2025, 6:20 AM · PostgreSQL, MediaWiki-Installer, MW-1.43-release

Oct 21 2025

saper added a comment to T402690: Upgrading from 1.39.4 to 1.43.3 leads to drop index pl_namespace error.

Do you still have backups of the old databases and can check if those indices existed at all in the old MediaWiki versions?

Oct 21 2025, 9:48 PM · PostgreSQL, MediaWiki-Installer, MW-1.43-release
saper added a comment to T407186: VARBINARY is not supported on PostgreSQL.

A quick fix for this is to extend the update hook to install different SQL files for MySQL and PostgreSQL.

Oct 21 2025, 9:31 PM · PostgreSQL, MediaWiki-extensions-WatchAnalytics
Aklapper added a comment to T402690: Upgrading from 1.39.4 to 1.43.3 leads to drop index pl_namespace error.

Please see https://www.mediawiki.org/wiki/Manual:Installing_MediaWiki#Set_up_the_database instead - thanks.

Oct 21 2025, 9:08 PM · PostgreSQL, MediaWiki-Installer, MW-1.43-release
Leduardomoreira added a comment to T402690: Upgrading from 1.39.4 to 1.43.3 leads to drop index pl_namespace error.

Hello joernc_unibi ,

Oct 21 2025, 4:52 PM · PostgreSQL, MediaWiki-Installer, MW-1.43-release
joernc_unibi added a comment to T402690: Upgrading from 1.39.4 to 1.43.3 leads to drop index pl_namespace error.

I'm not sure this is related to T330382 ... after all I seem to have reported that problem...

Oct 21 2025, 3:15 PM · PostgreSQL, MediaWiki-Installer, MW-1.43-release

Oct 14 2025

Aklapper added a comment to T407186: VARBINARY is not supported on PostgreSQL.

Hi @SamuelReichmannCongatec, thanks for taking the time to report this and welcome to Wikimedia Phabricator.

Oct 14 2025, 8:58 AM · PostgreSQL, MediaWiki-extensions-WatchAnalytics
Aklapper renamed T407186: VARBINARY is not supported on PostgreSQL from PostgreSQL Support to VARBINARY is not supported on PostgreSQL.
Oct 14 2025, 8:57 AM · PostgreSQL, MediaWiki-extensions-WatchAnalytics

Oct 10 2025

OKryva-WMF moved T366590: Multiple CheckUser tests are failing when using a postgres DB from Inbox to Later sprints on the Product Safety and Integrity board.
Oct 10 2025, 9:53 AM · Product Safety and Integrity, Essential-Work, MW-1.43-notes (1.43.0-wmf.9; 2024-06-11), PostgreSQL
OKryva-WMF edited projects for T366590: Multiple CheckUser tests are failing when using a postgres DB, added: Product Safety and Integrity; removed Trust and Safety Product Team.
Oct 10 2025, 9:53 AM · Product Safety and Integrity, Essential-Work, MW-1.43-notes (1.43.0-wmf.9; 2024-06-11), PostgreSQL
OKryva-WMF moved T397314: IPInfo PHPUnit tests fail when using an SQLite or PostgreSQL DB from Inbox to Later sprints on the Product Safety and Integrity board.
Oct 10 2025, 9:52 AM · Product Safety and Integrity, Essential-Work, PostgreSQL, SQLite, IP Info
OKryva-WMF edited projects for T397314: IPInfo PHPUnit tests fail when using an SQLite or PostgreSQL DB, added: Product Safety and Integrity; removed Trust and Safety Product Team.
Oct 10 2025, 9:52 AM · Product Safety and Integrity, Essential-Work, PostgreSQL, SQLite, IP Info

Oct 8 2025

Kgraessle moved T406676: RecentChanges with multiple change tags gives SQL error on PostgreSQL or strict mode from Inbox to Maintenance priorities on the Moderator-Tools-Team board.
Oct 8 2025, 6:06 PM · PostgreSQL, MediaWiki-Recent-changes, Moderator-Tools-Team
Reedy added a parent task for T406676: RecentChanges with multiple change tags gives SQL error on PostgreSQL or strict mode: T108255: Enable MariaDB/MySQL's Strict Mode.
Oct 8 2025, 9:37 AM · PostgreSQL, MediaWiki-Recent-changes, Moderator-Tools-Team
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits