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

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: WAL logs - do they operate at a database or cluster level?
Date: 2011-05-12 08:32:25
Message-ID: A2E53AF8AE1C284C8F8B648653C0920B1D6A4FA0@EXXMAIL02.desktop.frd.metoffice.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
<runtime-config-wal.html> and archive_command
<runtime-config-wal.html>
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?

Thanks
Austen

Austen Birchall Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom
Tel: +44 (0)1392 884481 Fax: +44 (0)1392 885681
E-mail: austen(dot)birchall(at)metoffice(dot)gov(dot)uk Website:
http://www.metoffice.gov.uk

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Riggs 2011-05-12 09:33:37 Re: WAL logs - do they operate at a database or cluster level?
Previous Message Sindile Bidla 2011-05-11 16:11:06 Re: Error in using copy command