PostgreSQL 15 preview - 增加GUC 参数 postgres_fdw.application_name 可以指定每个fdw连接的application_name

作者

digoal

日期

2021-09-07

标签

PostgreSQL , guc , postgres_fdw.application_name

增加GUC 参数 postgres_fdw.application_name 可以指定每个fdw连接的application_name

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=449ab6350526e99d33363706b759951ebad7928e

postgres_fdw: Allow application_name of remote connection to be set via GUC. master github/master  
author  Fujii Masao <fujii@postgresql.org>    
Tue, 7 Sep 2021 03:27:30 +0000 (12:27 +0900)  
committer   Fujii Masao <fujii@postgresql.org>    
Tue, 7 Sep 2021 03:27:30 +0000 (12:27 +0900)  
commit  449ab6350526e99d33363706b759951ebad7928e  
tree    3ca7c9bca2a856ed389d1a182667581ee6875e4d    tree  
parent  4c3478859b7359912d7e99fea702c56b1f53000c    commit | diff  
postgres_fdw: Allow application_name of remote connection to be set via GUC.  
This commit adds postgres_fdw.application_name GUC which specifies  
a value for application_name configuration parameter used  
when postgres_fdw establishes a connection to a foreign server.  
This GUC setting always overrides application_name option of  
the foreign server object. This GUC is useful when we want to  
specify our own application_name per remote connection.  
Previously application_name of a remote connection could be set  
basically only via options of a server object. But which meant that  
every session connecting to the same foreign server basically  
should use the same application_name. Also if we want to change  
the setting, we had to execute "ALTER SERVER ... OPTIONS ..." command.  
It was inconvenient.  
Author: Hayato Kuroda  
Reviewed-by: Masahiro Ikeda, Fujii Masao  
Discussion: https://postgr.es/m/TYCPR01MB5870D1E8B949DAF6D3B84E02F5F29@TYCPR01MB5870.jpnprd01.prod.outlook.com  
复制

PostgreSQL 许愿链接

您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.

9.9元购买3个月阿里云RDS PostgreSQL实例

PostgreSQL 解决方案集合

德哥 / digoal's github - 公益是一辈子的事.