Hi,
On alternate days my backup is failing, by the pg_stop_backup process ()
does not perform or quit.
Version PostgreSQL: 9.1.6
The following backup script:
PGDATA=/dados
SAVE_BASE_DIR=/backup/diario
backup="'bkpfull'"
data=$(date +'%d%m%y')
WAL_DIR=/backup/archive
mv $WAL_DIR/* $WAL_DIR/wal
Hello Robert,
Thanks for the feedback.
The my script works, but after a few days it stops working because the
process does not end pg_stop_backup.
The pg_basebackup already does this substitution?
--
View this message in context:
http://postgresql.nabble.com/Pg-stop-backup-process-does-not-r
Hi,
Thanks for the feedback.
Log:
LOG: connection authorized: user=postgres database=template1
LOG: statement: select pg_start_backup('bkpfull',true);
ERROR: a backup is already in progress
HINT: Run pg_stop_backup() and try again.
STATEMENT: select pg_start_backup('bkpfull',true);
LOG: di
