[Pgpool-general] archive_command question

[Tatsuo Ishii]

> > 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.

Probably what we need is "recovery_end_command" to be executed at the
very end of recovery. 

recovery_1st_stage_command enables archive_command and
recovery_end_command disables archive_command and remove archive logs
etc.
--
Tatsuo Ishii
SRA OSS, Inc. Japan