PostgreSQL 9.0 → 9.1 GUC 差异

PG9.0 与 PG9.1 之间新增、boot 默认值变化和移除的核心配置参数。

说明

Fact。 实测在档数从 207 变为 219；新增 12、boot 默认值变化 10、移除 0。

新增参数

参数	类型	Context	Boot 默认值	分类
`default_transaction_deferrable`	`bool`	`user`	`off`	Client Connection Defaults / Statement Behavior
`exit_on_error`	`bool`	`user`	`off`	Error Handling
`hot_standby_feedback`	`bool`	`sighup`	`off`	Replication / Standby Servers
`log_file_mode`	`integer`	`sighup`	`384`	Reporting and Logging / Where to Log
`max_pred_locks_per_transaction`	`integer`	`postmaster`	`64`	Lock Management
`quote_all_identifiers`	`bool`	`user`	`off`	Version and Platform Compatibility / Previous PostgreSQL Versions
`replication_timeout`	`integer`	`sighup`	`60000 ms` (1 min)	Replication / Master Server
`restart_after_crash`	`bool`	`sighup`	`on`	Error Handling
`ssl_ciphers`	`string`	`postmaster`	`ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH`	Connections and Authentication / Security and Authentication
`synchronous_standby_names`	`string`	`sighup`	`""` (empty string)	Replication / Master Server
`transaction_deferrable`	`bool`	`user`	`off`	Client Connection Defaults / Statement Behavior
`wal_receiver_status_interval`	`integer`	`sighup`	`10 s`	Replication / Standby Servers

Boot 默认值变化

参数	PG9.0	PG9.1	分类
`TimeZone`	`UNKNOWN`	— (not set)	Client Connection Defaults / Locale and Formatting
`krb_server_keyfile`	`""` (empty string)	`FILE:/etc/postgresql-common/krb5.keytab`	Connections and Authentication / Security and Authentication
`log_timezone`	`UNKNOWN`	— (not set)	Reporting and Logging / What to Log
`server_version`	`9.0.23`	`9.1.24`	Preset Options
`server_version_num`	`90023`	`90124`	Preset Options
`standard_conforming_strings`	`off`	`on`	Version and Platform Compatibility / Previous PostgreSQL Versions
`timezone_abbreviations`	`UNKNOWN`	— (not set)	Client Connection Defaults / Locale and Formatting
`transaction_isolation`	— (not set)	`default`	Client Connection Defaults / Statement Behavior
`wal_buffers`	`8 8kB` (64 KiB (8 × 8kB))	`-1 8kB`	Write-Ahead Log / Settings
`wal_sender_delay`	`200 ms`	`1000 ms` (1 s)	Replication / Master Server

移除参数

参数	最后类型	Context	最后 Boot 默认值	分类
—	—	—	—	—

计算方法

三张清单直接比较固定环境中的 PG9.0 与 PG9.1 pg_settings 快照。默认值变化使用 boot_val 与 unit 的组合；setting 不参与判定，以免把 initdb 生成值误当作编译时默认值。