PostgreSQL 9.2 → 9.3 GUC diff
Core configuration parameters added, removed, or changed in boot default between PostgreSQL 9.2 and 9.3.
Note
Fact. The measured inventory changes from 224 to 231 settings: 9 added, 3 boot-default changes, and 2 removed.
Added parameters
| Parameter | Type | Context | Boot default | Category |
|---|---|---|---|---|
autovacuum_multixact_freeze_max_age |
integer |
postmaster |
400000000 |
Autovacuum |
data_checksums |
bool |
internal |
off |
Preset Options |
ignore_checksum_failure |
bool |
superuser |
off |
Developer Options |
lock_timeout |
integer |
user |
0 ms |
Client Connection Defaults / Statement Behavior |
unix_socket_directories |
string |
postmaster |
/var/run/postgresql |
Connections and Authentication / Connection Settings |
vacuum_multixact_freeze_min_age |
integer |
user |
5000000 |
Client Connection Defaults / Statement Behavior |
vacuum_multixact_freeze_table_age |
integer |
user |
150000000 |
Client Connection Defaults / Statement Behavior |
wal_receiver_timeout |
integer |
sighup |
60000 ms (1 min) |
Replication / Standby Servers |
wal_sender_timeout |
integer |
sighup |
60000 ms (1 min) |
Replication / Sending Servers |
Boot-default changes
| Parameter | PG9.2 | PG9.3 | Category |
|---|---|---|---|
server_version |
9.2.23 |
9.3.25 |
Preset Options |
server_version_num |
90223 |
90325 |
Preset Options |
ssl_ciphers |
ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH |
DEFAULT:!LOW:!EXP:!MD5:@STRENGTH |
Connections and Authentication / Security and Authentication |
Removed parameters
| Parameter | Last type | Context | Last boot default | Category |
|---|---|---|---|---|
replication_timeout |
integer |
sighup |
60000 ms (1 min) |
Replication / Sending Servers |
unix_socket_directory |
string |
postmaster |
"" (empty string) |
Connections and Authentication / Connection Settings |
Method
The three lists compare the pinned PG9.2 and PG9.3 pg_settings snapshots directly. A default change is a change in the boot_val plus unit pair; setting is excluded so an initdb-generated value is not mistaken for the compiled boot default.