More WAL archiving/backup questions

Поиск
Список
Период
Сортировка
От Birchall, Austen
Тема More WAL archiving/backup questions
Дата
Msg-id A2E53AF8AE1C284C8F8B648653C0920B1D6A4FA8@EXXMAIL02.desktop.frd.metoffice.com
обсуждение исходный текст
Ответы Re: More WAL archiving/backup questions  (Joshua Tolley <eggyknap@gmail.com>)
Список pgsql-novice

Hi once again

Am I right to assume that running a pg_dumo -Fc against a database:

(i) Does not require WAL log archiving be be switched on?
(ii) That running this will have no (or a very small) effect on the database's performance?

Also in general, are there any performance hits from runing in WAL Archiving mode and also any when a pg_start_backup is actually running

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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: WAL logs - do they operate at a database or cluster level?
Следующее
От: e-letter
Дата:
Сообщение: select records by nearest value