作者
digoal
日期
2020-12-02
标签
PostgreSQL , restore_command , reload
背景
PostgreSQL 14支持restore_command修改, 无需重启.
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=942305a36365433eff3c1937945758f2dbf1662b
```
Allow restore_command parameter to be changed with reload.
author Fujii Masao fujii@postgresql.org
Wed, 2 Dec 2020 10:00:15 +0800 (11:00 +0900)
committer Fujii Masao fujii@postgresql.org
Wed, 2 Dec 2020 10:00:15 +0800 (11:00 +0900)
commit 942305a36365433eff3c1937945758f2dbf1662b
tree 7023fb4da694ee4ff435baa8782e0b8e70530fa0 tree | snapshot
parent 87ae9691d25379785f8c0f81b06a14818cfd8c56 commit | diff
Allow restore_command parameter to be changed with reload.
This commit changes restore_command from PGC_POSTMASTER to PGC_SIGHUP.
As the side effect of this commit, restore_command can be reset to
empty during archive recovery. In this setting, archive recovery
tries to replay only WAL files available in pg_wal directory. This is
the same behavior as when the command that always fails is specified
in restore_command.
Note that restore_command still must be specified (not empty) when
starting archive recovery, even after applying this commit. This is
necessary as the safeguard to prevent users from forgetting to
specify restore_command and starting archive recovery.
Thanks to Peter Eisentraut, Michael Paquier, Andres Freund,
Robert Haas and Anastasia Lubennikova for discussion.
Author: Sergei Kornilov
Reviewed-by: Kyotaro Horiguchi, Fujii Masao
Discussion: https://postgr.es/m/2317771549527294@sas2-985f744271ca.qloud-c.yandex.net
```
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
