Hey guys, as I wrote in this post [图片] Supported postgresql versions Self-hosting Hi, checked the dump being made in backup file: It includes this on top SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = ‘UTF8’; SET standard_conforming_strings = on; The parameter transaction_timeout is weird here thinking as transaction_timeout was added in PostgreSQL 17. stated here: https://pgpedia.info/t/transaction_timeout.html Need help slight_smile Thanks ! Cheers, Wurze… It seems, that a statement which has been added in PostGre 17 SET transaction_timeout = 0 is being used, and that brakes the restore ability. Any hints ? Thanks and Cheers, Wurzelseppi

You might need something like this: - exec: cd: /var/www/discourse cmd: - apt-get update && apt-get remove -y postgresql-client-15 && apt-get install -y postgresql-client-16 db:migrate'" I haven’t tested that yet, but something like it worked a few weeks ago with 13 instead of 15.

[图片] Wurzelseppi: that a statement which has been added in PostGre 17 Was your backup taken from a PostgreSQL 17 instance?

Hi Falco, no, my running DB instance is PostGres 16.4

That was the right lead, many thanks @pfaffman !! Installed the postgre client without version, and got the current one (17). Tis solved! Many thanks !

PostGres 17 在备份中的 statement 阻塞了恢复机制

产品支持

Falco (Falco) 2025 年2 月 3 日 14:41 2

您的备份是从 PostgreSQL 17 实例中获取的吗？

话题		回复	浏览量
Timeout when restoring a backup Self-hosting	1	954	2020 年11 月 16 日
Backups fail with Postgres 16 database (and all PG>13) Product Support	7	1042	2025 年6 月 14 日
Supported postgresql versions Self-hosting	17	3719	2025 年3 月 2 日
Trouble with restore: "invalid command \restrict" Product Support	2	1684	2025 年10 月 29 日
Restoring backup fails due to Postgres version mismatch Self-hosting	5	3430	2019 年2 月 14 日

PostGres 17 在备份中的 statement 阻塞了恢复机制

相关话题