Skip site navigation (1) Skip section navigation (2)

Re: WAL logs - do they operate at a database or cluster level?

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: WAL logs - do they operate at a database or cluster level?
Date: 2011-05-12 09:33:37
Message-ID: BANLkTik6xEVhdz7RSiPvngVy0rkzP_onwQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, May 12, 2011 at 9:32 AM, Birchall, Austen
<austen(dot)birchall(at)metoffice(dot)gov(dot)uk> wrote:
> Hi again and thanks for your help on my previous post.
>
> Now I ask:
> From the docs it seems that if I wish to enable WAL archiving for a database
> I change the settings of  archive_mode  and archive_command
>
> in the postgresql.conf  file.
> Am I right to assume that this enables WAL logging at a cluster level i.e.
> EVERY database in that cluster goes into WAL archive mode?

Yes, that's correct.

WAL logging is already enabled, with all databases going into the one
transaction log. Setting those parameters enables archiving of the WAL
data files.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

pgsql-novice by date

Next:From: Birchall, AustenDate: 2011-05-12 13:29:41
Subject: More WAL archiving/backup questions
Previous:From: Birchall, AustenDate: 2011-05-12 08:32:25
Subject: WAL logs - do they operate at a database or cluster level?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group