هل هناك أي فرصة لترقية إصدار postgres-client؟

تثبيت
1

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_dump: error: server version: 14.1 (Ubuntu 14.1-1.pgdg18.04+1); pg_dump version: 13.5 (Debian 13.5-1.pgdg100+1)
[2022-01-17 03:38:08] pg_dump: error: aborting because of server version mismatch
[2022-01-17 03:38:08] EXCEPTION: pg_dump failed

Is there any way to upgrade the postgresql-client 13.5-1.pgdg100+1 of the container to version 14?

إعجاب واحد (1)
2

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).

إعجاب واحد (1)
3

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 turns us to be devout Catholics - many prayers beforehand, but still a lot of blood, sweat and tears.

إعجابَين (2)
4

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

3 إعجابات
5

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 rebuilding the app inside China. That’s the reason why I would like to clarify if just entering the app and then manually installing it via apt would do the trick.

3 إعجابات
6

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.

إعجابَين (2)
7

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

8

Should I open a new ticket for Backup failure ?

9

??? 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

10

to officially support it, yes.

4 إعجابات