Skip site navigation (1) Skip section navigation (2)

More WAL archiving/backup questions

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: More WAL archiving/backup questions
Date: 2011-05-12 13:29:41
Message-ID: (view raw or whole thread)
Lists: 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



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:


pgsql-novice by date

Next:From: e-letterDate: 2011-05-14 10:49:16
Subject: select records by nearest value
Previous:From: Simon RiggsDate: 2011-05-12 09:33:37
Subject: Re: WAL logs - do they operate at a database or cluster level?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group