Re: [HACKERS] Pg_stop_backup process does not run - Backup Intervals

2016-05-05 Thread Rodrigo Cavalcante
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

Re: [HACKERS] Pg_stop_backup process does not run - Backup Intervals

2016-05-03 Thread David G. Johnston
On Mon, May 2, 2016 at 12:03 PM, Rodrigo Cavalcante wrote: > 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 producti

Re: [HACKERS] Pg_stop_backup process does not run - Backup Intervals

2016-05-03 Thread Robert Haas
On Tue, May 3, 2016 at 4:21 PM, Rodrigo Cavalcante 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 alread

Re: [HACKERS] Pg_stop_backup process does not run - Backup Intervals

2016-05-03 Thread Rodrigo Cavalcante
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

Re: [HACKERS] Pg_stop_backup process does not run - Backup Intervals

2016-05-03 Thread Robert Haas
On Mon, May 2, 2016 at 3:03 PM, Rodrigo Cavalcante 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'" > da