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

**URL:** <https://meta.discourse.org/t/postgres-17-statement-in-backups-is-blocking-restore-mechanism/350207>\
**Category:** Support\
**Created:** [2025年二月3日 06:00 UTC](https://meta.discourse.org/t/postgres-17-statement-in-backups-is-blocking-restore-mechanism/350207 "2025-02-03T06:00:11Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Wurzelseppi](https://avatars.discourse-cdn.com/v4/letter/w/eada6e/32.png) [@Wurzelseppi](https://meta.discourse.org/u/Wurzelseppi)\
**Post date:** [2025年二月3日 06:00 UTC](https://meta.discourse.org/t/postgres-17-statement-in-backups-is-blocking-restore-mechanism/350207/1 "2025-02-03T06:00:11Z")

</div>

各位，

正如我在这个帖子中所写：

> [@Supported postgresql versions](https://meta.discourse.org/t/supported-postgresql-versions/174751/17?u=wurzelseppi):
>
> 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](https://pgpedia.info/postgresql-versions/postgresql-17.html). stated here: [https://pgpedia.info/t/transaction\_timeout.html](https://pgpedia.info/t/transaction_timeout.html) Need help slight_smile Thanks ! Cheers, Wurze…

似乎PostgreSQL 17中添加的一个语句

> SET transaction\_timeout = 0

正在被使用，这破坏了恢复能力。

有什么线索吗？

谢谢，祝好，  
Wurzelseppi

---

_[View the full topic](https://meta.discourse.org/t/postgres-17-statement-in-backups-is-blocking-restore-mechanism/350207)._