Introduce wal_level GUC to explicitly control if information needed for
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 28 Apr 2010 16:10:43 +0000 (16:10 +0000)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 28 Apr 2010 16:10:43 +0000 (16:10 +0000)
commit9b8a73326e99821caf33c36c081cb307e17422d4
tree6ba969ff6d18829c87fde36b9608f4d051cc7b8c
parenta2de4826e912057a9a3c44e6c4c204dfa3b753a9
Introduce wal_level GUC to explicitly control if information needed for
archival or hot standby should be WAL-logged, instead of deducing that from
other options like archive_mode. This replaces recovery_connections GUC in
the primary, where it now has no effect, but it's still used in the standby
to enable/disable hot standby.

Remove the WAL-logging of "unlogged operations", like creating an index
without WAL-logging and fsyncing it at the end. Instead, we keep a copy of
the wal_mode setting and the settings that affect how much shared memory a
hot standby server needs to track master transactions (max_connections,
max_prepared_xacts, max_locks_per_xact) in pg_control. Whenever the settings
change, at server restart, write a WAL record noting the new settings and
update pg_control. This allows us to notice the change in those settings in
the standby at the right moment, they used to be included in checkpoint
records, but that meant that a changed value was not reflected in the
standby until the first checkpoint after the change.

Bump PG_CONTROL_VERSION and XLOG_PAGE_MAGIC. Whack XLOG_PAGE_MAGIC back to
the sequence it used to follow, before hot standby and subsequent patches
changed it to 0x9003.
22 files changed:
doc/src/sgml/backup.sgml
doc/src/sgml/config.sgml
doc/src/sgml/high-availability.sgml
doc/src/sgml/perform.sgml
src/backend/access/heap/rewriteheap.c
src/backend/access/nbtree/nbtsort.c
src/backend/access/transam/xlog.c
src/backend/commands/cluster.c
src/backend/commands/copy.c
src/backend/commands/tablecmds.c
src/backend/executor/execMain.c
src/backend/postmaster/postmaster.c
src/backend/replication/walsender.c
src/backend/storage/ipc/standby.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/bin/pg_controldata/pg_controldata.c
src/bin/pg_resetxlog/pg_resetxlog.c
src/include/access/xlog.h
src/include/access/xlog_internal.h
src/include/catalog/pg_control.h
src/include/replication/walsender.h