Page MenuHomePhabricator

Allow Vagrant to set up a PostgreSQL database backend
Open, LowestPublic

Description

Currently, to set up a test site for PostgreSQL development you need to do it manually, and if you encounter any obstacles, you're on your own compared to the number of MySQL developers. In addition, MySQL developers have MediaWiki-Vagrant which ensures that developers have a reproducible environment that is independent of whatever customizations they did to their system.

MediaWiki-Vagrant should offer that functionality for PostgreSQL as well so that MediaWiki developers can easily test features or debug issues caused by different SQL syntax, etc.

There is a broader approach in T73235 for choosing between MySQL and MariaDB, and a similar request for SQLite with T67843, but I think it would be sufficient for the moment to have a vagrant config item db_type defaulting to mysql that, when set to postgres, would instead install a PostgreSQL server and configure MediaWiki accordingly.

AFAICT, the Vagrant configuration is passed to the guest VM as Puppet facts. There are a number of MediaWiki-Vagrant roles that explicitly use resources of the mysql module to set up databases & Co., but these could be extended at a later stage (if they are used outside WMF).

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

scfc created this task.Oct 26 2015, 4:06 PM
scfc updated the task description. (Show Details)
scfc raised the priority of this task from to Lowest.
scfc added a project: MediaWiki-Vagrant.
scfc added subscribers: scfc, saper, Jjanes.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 26 2015, 4:06 PM
scfc updated the task description. (Show Details)Nov 1 2015, 4:16 AM
scfc claimed this task.
scfc set Security to None.

I chose db_type over db_backend and postgres over postgresql to be in line with the arguments to the command line installer.

Change 250361 had a related patch set uploaded (by Tim Landscheidt):
Add support for PostgreSQL backend

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

Jdforrester-WMF added a subscriber: Jdforrester-WMF.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.

scfc removed scfc as the assignee of this task.Feb 28 2017, 1:59 AM
scfc moved this task from Awaiting review to Backlog on the MediaWiki-Vagrant board.

I did not rebase this change in the past year, so unassigning. This isn't rocket science, but requires a thorough understanding of the current MediaWiki-Vagrant Puppet structure and its interactions.