Pg_stop_backup process does not run - Backup Intervals

Поиск
Список
Период
Сортировка
От Rodrigo Cavalcante
Тема Pg_stop_backup process does not run - Backup Intervals
Дата
Msg-id 1462215824301-5901538.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Pg_stop_backup process does not run - Backup Intervals  (Robert Haas <robertmhaas@gmail.com>)
Re: Pg_stop_backup process does not run - Backup Intervals  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
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_anterior

psql -U postgres -h localhost -c 'select pg_start_backup('$backup',true);'
template1 && \

tar -czvf $SAVE_BASE_DIR/$data.tar.gz $PGDATA && psql -U postgres -h
localhost -c 'select pg_stop_backup();' template1



--
View this message in context:
http://postgresql.nabble.com/Pg-stop-backup-process-does-not-run-Backup-Intervals-tp5901538.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_upgrade and toasted pg_largeobject
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions