Обсуждение: Pg_stop_backup process does not run - Backup Intervals
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.
On Mon, May 2, 2016 at 3:03 PM, Rodrigo Cavalcante
<rodrigo.java@gmail.com> wrote:
> 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
I'm going to refer you to
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
You aren't being very clear about what actually happens here, and you
haven't mentioned what showed up in the logs, either. If I had to
guess, I'd guess that if you look at the output of this backup script
on alternate days, you'll find that some step in here is failing on
alternate days, with an error message to tell you which step is
failing and in what way. That might help you figure out the problem.
Also, consider using one of the various backup toolkits that already
exist instead of writing your own script. Also, consider using
pg_basebackup. These tend to be more reliably than home-grown
scripts.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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-run-Backup-Intervals-tp5901538p5901757.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
On Tue, May 3, 2016 at 4:21 PM, Rodrigo Cavalcante <rodrigo.java@gmail.com> wrote: > The my script works, but after a few days it stops working because the > process does not end pg_stop_backup. Well, that shouldn't happen, but without any logs or debugging information, it's hard to guess why. > The pg_basebackup already does this substitution? If you use pg_basebackup, you don't need to run pg_start_backup() or pg_stop_backup(). -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Hi,
On alternate days my backup is failing, by the pg_stop_backup process ()
does not perform or quit.
Version PostgreSQL: 9.1.6
Reporting unusual behavior while running a years-old point release is unlikely to be productive. No one wants to debug something that very well may have been fixed in the meantime.
And, as Robert said, you need to provide considerably more detail than you have if you wish to get help diagnosing your situation. And I too would recommend you not "roll your own" in this area unless you are trying to learn, at a lower-level, how these things work.
David J.
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: disconnection: session time: 0:00:00.165 user=postgres
database=template1 host=localhost port=45746
I will use the pg_basebackup.
--
View this message in context:
http://postgresql.nabble.com/Pg-stop-backup-process-does-not-run-Backup-Intervals-tp5901538p5902082.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.