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

Поиск
Список
Период
Сортировка
От Birchall, Austen
Тема WAL logs - do they operate at a database or cluster level?
Дата
Msg-id A2E53AF8AE1C284C8F8B648653C0920B1D6A4FA0@EXXMAIL02.desktop.frd.metoffice.com
обсуждение исходный текст
Ответы Re: WAL logs - do they operate at a database or cluster level?  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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  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 по дате отправления:

Предыдущее
От: Sindile Bidla
Дата:
Сообщение: Re: Error in using copy command
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: WAL logs - do they operate at a database or cluster level?