We are using Discourse with an external database instead of the integrated, Docker-based Postgres. We recently had to upgrade our Postgres cluster to 14, thus the Discourse backup keeps failing. Log output [2022-01-17 03:38:08] Dumping the public schema of the database... [2022-01-17 03:38:08] pg_…

We upgrade Postgres versions every two releases, because it takes a tremendous amount of engineering resources to upgrade the database. We are currently on Postgres 13 so we’ll upgrade to Postgres 15.1 when that is released (the bugfix point release).

[image] codinghorror: it takes a tremendous amount of engineering resources to upgrade the database I do understand, but thanks for pointing out the upgrade policy - really good to know. We are aware of engineering resources regarding the DB. I love Postgres, but upgrading our cluster usually…

You should be able to manually install the required postgresql-client by adding the appropriate apt-get commands to your app.yml.

Would this cause any depency issues with Ruby gems of the application itself? As far as I understand adding apt install as a hook requires a launcher rebuild app, right? If so, I would skip this for another dreaded upgrade as described here in another topic of mine , we face massive problems of rebu…

I suggest you test it on a staging site before doing anything in production, but I think there won’t be any issues with Ruby gems. Installing it in the running container should work as well.

So you will create the script next year in 2023 ? PostgreSQL: Versioning Policy

Should I open a new ticket for Backup failure ?

??? it takes a tremendous amount of engineering resources ??? It seems that these simple lines of commands to update the postgresql database from 13.5 to 14.1 solve the backup problem… Cheers cd /var/discourse ./launcher enter app sudo apt-get install postgresql

[image] Donavan_Martin1: it takes a tremendous amount of engineering resources to officially support it, yes.

Any chance to upgrade the postgres-client version?

Product Support Self-hosting

supermathie (Michael Brown) February 5, 2022, 6:00pm 10

to officially support it, yes.

Topic		Replies	Views
Supported postgresql versions Self-hosting	17	3675	March 2, 2025
Can I use a later version of Postgres than Discourse? Self-hosting	4	1406	January 20, 2022
Backups fail with Postgres 16 database (and all PG>13) Product Support	7	997	June 14, 2025
Backup fails with postgres 18 Product Support	9	675	May 21, 2026
Manual upgrade fails Self-hosting	11	2209	January 23, 2020

Any chance to upgrade the postgres-client version?

Related topics