Page MenuHomeDevCentral
Create Task
Maniphest T2186

Upgrade to PostgreSQL 17
Open, HighPublic
Actions

Description

There is currently a wheel war between:

  • the version installed by roles/dbserver-pgsql, PostgreSQL 15
  • PHP extension pdo_pgsql, requiring PostgreSQL 17

On devserver role, if we update the system packages, it will upgrade the client to 17, but if we reapply roles/dbserver-pgsql/server afterwards, it restore client to 15.

Plan is to upgrade in the role dbserver-pgsql to PostgreSQL 17.

rOPS change:

  • hunt references to PostgreSQL 15 and update to 17

Servers:

  • WindRiver
  • db-A-001

References:

Revisions and Commits

rOPS Nasqueron Operations
D3874rOPS0d41a256ff72 Upgrade PostgreSQL version to 17

Event Timeline

dereckson triaged this task as High priority.Tue, Nov 11, 02:13
dereckson created this task.
dereckson added projects: Servers, DBA.
dereckson claimed this task.Tue, Nov 11, 13:50
dereckson raised the priority of this task from High to Unbreak Now!.

Taking this, we've PostgreSQL deinstalled on WindRiver; as we're on a UNIX system, it still runs without any issue as long as it doesn't need to load dynamically a library, accepts connection, serves traffic but software isn't there anymore.

dereckson moved this task from Next to Working on on the Operations sprints (Echoes in the Void) board.Tue, Nov 11, 13:50
dereckson added a revision: D3874: Upgrade PostgreSQL version to 17.Tue, Nov 11, 13:53
dereckson added a commit: rOPS0d41a256ff72: Upgrade PostgreSQL version to 17.Tue, Nov 11, 14:37
dereckson lowered the priority of this task from Unbreak Now! to High.EditedTue, Nov 11, 16:06

Deployed for WindRiver, server now runs on 17.6.

Decreasing priority as no wheelwar will exist on db-A: php83-pdo_pgsql isn't declared there.

dereckson updated the task description. (Show Details)Tue, Nov 11, 16:07
dereckson updated the task description. (Show Details)
dereckson moved this task from Working on to Next on the Operations sprints (Echoes in the Void) board.
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator