To: pgsql-admin@postgresql.org
Subject: =?UTF-8?Q?archive=5Ftimeout=20-=20Is=20it=20working=3F=3F?=
MIME-Version: 1.0
Date: Fri, 06 Jun 2008 12:06:34 +1000
From: Steve Kecskes <steve@outtalimits.com.au>
Message-ID: <bae14b947c4c50e9664e980c0f935bb4@outtalimits.com.au>
User-Agent: RoundCube Webmail/0.1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit


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