Implement archive_timeout feature to force xlog file switches to occur no more
Tom Lane <tgl@sss.pgh.pa.us>
Implement archive_timeout feature to force xlog file switches to occur no more than N seconds apart. This allows a simple, if not very high performance, means of guaranteeing that a PITR archive is no more than N seconds behind real time. Also make pg_current_xlog_location return the WAL Write pointer, add pg_current_xlog_insert_location to return the Insert pointer, and fix pg_xlogfile_name_offset to return its results as a two-element record instead of a smashed-together string, as per recent discussion. Simon Riggs
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/backup.sgml | modified | +25 −32 |
| doc/src/sgml/config.sgml | modified | +30 −1 |
| doc/src/sgml/func.sgml | modified | +28 −10 |
| src/backend/access/transam/xlog.c | modified | +107 −14 |
| src/backend/postmaster/bgwriter.c | modified | +54 −5 |
| src/backend/utils/misc/guc.c | modified | +12 −2 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +3 −2 |
| src/include/access/xlog.h | modified | +2 −1 |
| src/include/access/xlog_internal.h | modified | +10 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +5 −3 |