From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Dennis Thrysøe <dth@geysirit.dk>
To: pgsql-admin@postgresql.org
Subject: Re: WARM standby with pg_standby
Date: Thu, 08 Apr 2010 11:36:27 -0500
Message-ID: <4BBDBFBB020000250003059F@gw.wicourts.gov> (raw)
In-Reply-To: <1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk>
References: <1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk>
Dennis Thrysøe<dth@geysirit.dk> wrote:
> 1) The master keeps writing WAL files even though I'm quite sure
> nothing is happening. This seems like a large waste of diskspace?
What is your setting for archive_timeout? This limits how long
before a WAL file is sent. You could extend the time, although that
means that in case of a failure, you might not be as up-to-date.
Another option is to use pg_clearxlogtail with gzip or use
pglesslog. I haven't used pglesslog, but piping an empty WAL file
through pg_clearxlogtail and gzip reduces it to about 16 kB (rather
than 16 MB).
> 2) Sometimes my slave does not read and delete WAL files when in
> recovery mode. This will eventually fill up the disk.
Sorry I can't help with that one -- we use our own scripts rather
than pg_standby. Anyone else recognize this issue?
> pg_controldata gives me:
>
> Minimum recovery ending location: 0/0
>
> What does that mean?
I think that only has meaning when the cluster is in archive
recovery status. What does pg_controldata say the "Database cluster
state" is when you see this?
> Is there any good ways of troubleshooting the behaviour, and
> finding out precisely what state the slave is in, etc.?
We use pg_controldata and check "Database cluster state" to ensure
that our warm standbys are still "in archive recovery" and we check
the "Time of latest checkpoint" to ensure that its age is not much
beyond our archive_timeout setting -- to ensure that the data is
indeed still flowing.
I believe that 9.0 will be adding some nicer ways to check such
things.
-Kevin
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: Kevin.Grittner@wicourts.gov, dth@geysirit.dk
Subject: Re: WARM standby with pg_standby
In-Reply-To: <4BBDBFBB020000250003059F@gw.wicourts.gov>
* 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