##全局修改
1：修改postgresql.conf
2:alter system set list_addresses=‘*‘;
##database级别修改
3:alter database name set configparameter [to|=] [value | default]
4:alter database reset configuration
##session级别修改
5:set configparameter [to|=] [value | default]
6:set configparameter to default
##修改配置文件视图
7:update pg_setting set setting=new_value where name =‘configparameter ‘
8:update pg_setting set setting=reset_val where name =‘configparameter ‘
##查看参数
9: select set_config(‘configparameter ‘,new_value,false);
10:select current_setting(name);
11:select name,setting from pg_settings where name=‘xxx‘;
##参数修改生效
12:select pg_reload_config();
以上截取自《pg实战》