Page MenuHomeDevCentral

Upgrade to PostgreSQL 17
Open, HighPublic

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:

Event Timeline

dereckson triaged this task as High priority.Nov 11 2025, 02:13
dereckson created this task.
dereckson added projects: Servers, DBA.
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 lowered the priority of this task from Unbreak Now! to High.EditedNov 11 2025, 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)
dereckson removed dereckson as the assignee of this task.Mon, Mar 23, 09:23

Unassigning this task to make it available for others.

As I'm not currently working actively on this issue, reset the assignee.

Contributions opportunity. If you’re interested, go ahead and assign yourself. I’m available to share context, review early approaches, or pair if helpful—just tag me.