> > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
