Backups no longer work for a postgres 16 database due to this commit that installs postgresql-client-${PG_MAJOR} rather than postgresql-client Is this solving a problem? Wasn’t the OS-provided psql client working just fine with all versions of postgres? I was surprised that this client was using P…

[画像] Jay Pfaffman: Is this solving a problem? Yep, that seems to be the case. From the PR : I discovered this bug when a Discourse backup was taken using pg_dump versioned 17.2 which cannot be restored onto postgres clusters < 17.2. Seems like you’re between a rock and a hard place here ( P…

[画像] Richard - Communiteq: From the PR : Oops. And I thought I read the PR. Given that I am a native English speaker with a PhD, you’d think I could do better. :person_shrugging: [画像] Jay Pfaffman: Maybe I can set PG_MAJOR in an ENV variable? No. I can’t, since this is what builds the …

Do the backups fail silently?? (I see my ordinary installation is using version 13, so I take it that this situation is a bit special, although perhaps not terribly rare.)

[画像] Ed S: Do the backups fail silently?? They do not. So it’s pretty obvious, and should happen only to people who know enough to manage their own postgres.

Hi all, I ran into this issue today. The symptom was we’d been getting alerts for 6 days or so that backups were failing, and the key log lines appeared to be: [2025-06-14 03:30:20] pg_dump: error: aborting because of server version mismatch [2025-06-14 03:30:20] pg_dump: detail: server version: 16…

I think somewhere here i provide the stuff to put those commands on your app.yml. You can look at the postgres templates for examples, maybe.

Thanks, but I’m not sure I follow. I’m under the impression that the YAML you mentioned in the original post above was simply a way to reduce the commands from the handful I posted above to a single one, but that you still had to manually run it each time you upgrade discourse. Have I misinterpreted…

Postgres 16データベースでバックアップが失敗する (PG>13も含む)

サポート

pfaffman (Jay Pfaffman) 2025 年 6 月 14 日午後 11:06 7

どこかに、app.ymlにこれらのコマンドを配置するための情報を提供していると思います。

例として、Postgresのテンプレートを見てみてください。

トピック		返信	表示
Backup Failed error Support	4	226	2025 年 5 月 8 日
Backup fails with postgres 18 Support	9	257	2026 年 5 月 21 日
Can I use a later version of Postgres than Discourse? Self-hosting	4	1201	2022 年 1 月 20 日
Any chance to upgrade the postgres-client version? Self-hosting	9	2059	2022 年 2 月 5 日
Restoring backup fails due to Postgres version mismatch Self-hosting	5	3343	2019 年 2 月 14 日

Postgres 16データベースでバックアップが失敗する (PG>13も含む)

関連トピック