Is there somewhere a note, which postgresql db versions are supported? Would be great to have something for each released discourse version - especially if a postgresql version is no longer supported.

Postgres is bundled in with the Docker container for Discourse, so this is generally hands-off. The Discourse team upgrades the Postgres version as new releases come out and they are properly tested. The most recent upgrade was to version 13. You can see the details of that upgrade here: …

Well, not everyone is using the bundled postgres db.

The current install doc lists Postgres 10+ as the required version: docs/INSTALL.md main To install and self-host Discourse, follow the steps below. But if you'd rather skip the setup, maintenance, and server management, our official Discourse hosting takes care of everything f…

[изображение] sbernhard: Is there somewhere a note, which postgresql db versions are supported? Yes, the versions of postgres which are “supported” (from a docker build perspective, not all “strongly supported”) are listed in the templates directory of discourse_docker discourse_dock…

Checking in three years later: The docker template still says PG_MAJOR=13, but there are new versions of PostgreSQL : 14 from 2021, 15 from 2022, and 16 from 2023. So the recommendation is still to use version 13 (which will EOL in 2025) rather than the latest PostgreSQL 16 (which will EOL in 2028)? …

[изображение] chkno: So the recommendation is still to use version 13 Yes, exactly. We have some sites running version 15 already, and should get to updating from 13 next year.

Question: what is the current status here? I am running an external pg database and would like to upgrade the database server from 13. postgres 16 was released 2023-09-14. Can it be used with discourse? Will there be any migration steps required for the database itself? (aside from the global migra…

PostgreSQL 13 is still the officially supported version, with version 13.15 being released last month and still supported. We have a good number of sites running version 15, and that is a known working version that we plan on shipping an update for self-hosted users eventually. Version 16 is not w…

Does Discourse do anything out of the ordinary with Postgres which would imply that upgrades to new versions of Postgres might not work with a simple dump and restore?

Bumping up this thread to see if there is a reason to try to upgrade to PostgreSQL 15 instead of 16 or 17? And when should we expect to upgrade the PostgreSQL

Поддерживаемые версии PostgreSQL

Поддержка Самостоятельное хостинг

jimmy0017 06.Октябрь.2024 21:14:20 11

Поднимаю эту тему, чтобы узнать, есть ли причина пытаться обновиться до PostgreSQL 15 вместо 16 или 17?

И когда мы должны ожидать обновления PostgreSQL?

Тема		Ответов	Просм.
Can I use a later version of Postgres than Discourse? Self-hosting	5	1193	20.01.2022
Upgrade failed spectacularily Support	25	735	10.02.2025
Forum crashes after upgrading from 2.4.0 Self-hosting	10	1267	03.08.2020
Stuck and lost updating forum, problems with PG migration Self-hosting	15	424	12.06.2025
Backup has failed. pg_dump: server version: 9.6.3; pg_dump version: 9.5.10 Development	8	9131	02.12.2017

Поддерживаемые версии PostgreSQL

Связанные темы