pg_start_backup(): backup already running

[mani...@gmail.com]

Hi everyone,

I canceled a backup operation with CTRL^C (I know it's bad) and now I cannot run any backup :

$ barman backup --reuse-backup=link bdd01
Starting backup for server bdd01 in /data/pgbarman/bdd01/base/20150410T093434
ERROR: Backup failed issuing start backup command.
DETAILS: pg_start_backup(): ERREUR:  une sauvegarde est d?j? en cours
HINT:  Ex?cutez pg_stop_backup() et tentez de nouveau.
Processing xlog segments for bdd01
    00000003000003CE0000000E

 

It says that a backup is already running.

When I run pg_stop_backup() or select pg_stop_backup() on the Postgresql server, nothing happens.

I think the solution is to restart Postgresql, but I'm afraid of losing data or not being able to start at all because I don't know exactly what pg_start_backup() did.

Debian Wheezy + Postgresql 9.1 + Barman 1.4.0.

Regards,

Xavier C.

[Joseph Kregloh]

If you had a newer version of Postgresql you could just run pg_is_in_backup() and see if it is in backup mode. When you do a pg_stop_backup() it should say that there is not backup in process or it should actually stop the backup process. Is the Barman process still running?

-Joseph Kregloh

--
--
You received this message because you are subscribed to the "Barman for PostgreSQL" group.
To post to this group, send email to pgba...@googlegroups.com
To unsubscribe from this group, send email to
pgbarman+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/pgbarman?hl=en?hl=en-GB

---
You received this message because you are subscribed to the Google Groups "Barman, Backup and Recovery Manager for PostgreSQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgbarman+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mani...@gmail.com]

Friday afternoon, late, I ran select pg_stop_backup(); again and this time it worked.

Thank you for your answer.

Xavier C.