From e8ea9e9587f096fdfbd4e451e2e88afee9009902 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 17 Aug 2006 23:04:10 +0000 Subject: 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 --- src/backend/utils/misc/postgresql.conf.sample | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index b0c6cdf7634..fcb81d71188 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -167,8 +167,9 @@ # - Archiving - -#archive_command = '' # command to use to archive a logfile - # segment +#archive_command = '' # command to use to archive a logfile segment +#archive_timeout = 0 # force a logfile segment switch after this + # many seconds; 0 is off #--------------------------------------------------------------------------- -- cgit v1.2.3