[Pgpool-general] archive_command question

[Jaume Sabater]

On Tue, Apr 14, 2009 at 3:25 PM,  <Daniel.Crespo at l-3com.com> wrote:

> I know this is a question for postgresql forum, but I think is convenient to
> know it in this forum as well. Does the ‘archive_command’ run if and only if
> the postgresql stored procedure named ‘pg_start_backup’ is called? My
> concern is that if archiving is enabled, the backup files would fill the
> disk space. If instead, every time I’m going to recover a failed node, I
> would just need to empty the archive directory before issuing
> pg_start_backup. Does this make sense?

You only need to set archive_command just before starting the online
recovery process. You do not need to have PostgreSQL archiving binary
logs all the time.

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"