FAQ
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.birchall@metoffice.gov.uk Website:
http://www.metoffice.gov.uk

Search Discussions

  • Simon Riggs at May 12, 2011 at 9:41 am

    On Thu, May 12, 2011 at 9:32 AM, Birchall, Austen 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 12, '11 at 8:32a
activeMay 12, '11 at 9:41a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Birchall, Austen: 1 post Simon Riggs: 1 post

People

Translate

site design / logo © 2022 Grokbase