Postgres Pro
Downloads
Home   >   mailing lists

WAL logs - do they operate at a database or cluster level? - Mailing list pgsql-novice

From Birchall, Austen
Subject WAL logs - do they operate at a database or cluster level?
Date
Msg-id A2E53AF8AE1C284C8F8B648653C0920B1D6A4FA0@EXXMAIL02.desktop.frd.metoffice.com
Whole thread Raw
Responses Re: WAL logs - do they operate at a database or cluster level?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-novice
Tree view

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?

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

pgsql-novice by date:

Previous
From: Sindile Bidla
Date:
Subject: Re: Error in using copy command
Next
From: Simon Riggs
Date:
Subject: Re: WAL logs - do they operate at a database or cluster level?