fix(db): make pg_upgrade 13->17 idempotent and use the cluster's real install user #15

2026-06-16T18:33:30Z

notplants commented

2026-06-16 18:33:30 +00:00

while deploying the previous PR (#14) to an older client, ran into an issue with the bespoke postgres update script (the install user used to originally create the database was different than expected)

this PR fixes the issue, so I am merging now, in case anyone upgrading from a very old deployment also has this issue

but it raises the desire to get off of this bespoke upgrade script and instead use pgautoupgrade. as mentioned in the other PR, this is unfortunately currently incompatible with pgvector or any of the existing published discourse images that I know of (the best solution may require publishing our own discourse image that uses pgautoupgrade and does not depend on pgvector)

however, merging this for now as this is the most immediate fix to keep the upgrade path seamless

while deploying the previous PR (https://git.coopcloud.tech/coop-cloud/discourse/pulls/14) to an older client, ran into an issue with the bespoke postgres update script (the install user used to originally create the database was different than expected) this PR fixes the issue, so I am merging now, in case anyone upgrading from a very old deployment also has this issue but it raises the desire to get off of this bespoke upgrade script and instead use pgautoupgrade. as mentioned in the other PR, this is unfortunately currently incompatible with pgvector or any of the existing published discourse images that I know of (the best solution may require publishing our own discourse image that uses pgautoupgrade and does not depend on pgvector) however, merging this for now as this is the most immediate fix to keep the upgrade path seamless

notplants added 1 commit 2026-06-16 18:33:31 +00:00

fix(db): make pg_upgrade 13->17 idempotent and use the cluster's real install user

continuous-integration/drone/pr Build is failing

Details

a9f08eed28

notplants referenced this pull request

2026-06-16 18:34:26 +00:00

Fix backup/restore #14

notplants merged commit 2b28de444d into main

2026-06-16 18:36:01 +00:00

notplants deleted branch idempotent

2026-06-16 18:36:02 +00:00