Pg_stop_backup process does not run - Backup Intervals - Mailing list pgsql-hackers

From Rodrigo Cavalcante
Subject Pg_stop_backup process does not run - Backup Intervals
Date
Msg-id 1462215824301-5901538.post@n5.nabble.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_upgrade and toasted pg_largeobject
Next
From: Andres Freund
Date:
Subject: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions