From: Steve Kecskes <steve@outtalimits.com.au>
To: pgsql-admin@postgresql.org
Subject: archive_timeout - Is it working??
Date: Fri, 06 Jun 2008 12:06:34 +1000
Message-ID: <bae14b947c4c50e9664e980c0f935bb4@outtalimits.com.au> (raw)
Hi,
I am currently setting up a warm standby configuration with Postgres 8.3.
Everything seems to be fine but the archive timeout doesnt seem to be
working as expected. The setup is currently in a test environment and I
have set the archive_timeout to be 60sec. The WAL logs however only seem to
be written out when the checkpoint_timeout expires. There is currently very
small amount of database activity in the test environment. But I would have
expected a WAL log be written every 60sec with maybe 1MB of data.
This is what I have set up for testing purposes:
# - Checkpoints -
checkpoint_segments = 3 # in logfile segments, min 1, 16MB
each
checkpoint_timeout = 5min # range 30s-1h
#checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 -
1.0
#checkpoint_warning = 30s # 0 is off
# - Archiving -
archive_mode = on
archive_command = 'cp -i "%p" /pgbackup/"%f" </dev/null'
archive_timeout = 60s
Is there something I am missing here?
Thanks!
--
-------------------------------------------------
Steve K
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: steve@outtalimits.com.au
Subject: Re: archive_timeout - Is it working??
In-Reply-To: <bae14b947c4c50e9664e980c0f935bb4@outtalimits.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox