The Database system is in recovery mode... BUT IT ISNT!

2,174 views
Skip to first unread message

Kobi Rosenstein

unread,
Mar 15, 2017, 5:14:56 AM3/15/17
to Barman, Backup and Recovery Manager for PostgreSQL
I have 2 servers which barman recognizes.
On both of them, barman check returns
ssh: ok
postgresql: failed

Everything else is OK. On checking the barman log I see
barman.server WARNING: Error retreiving Postgresql Status: FATAL:  the database system is in recovery mode

When I copy the conninfo from ~/.barman.conf (which is identical to /etc/barman.conf) for main, or from /etc/barman.d/SERVERNAME.conf for the second sever, and run it in psql, it connects just fine and  selecting pg_is_in_recovery(); returns f. on the database host running pg_controldata | grep "Database cluster state" returns in production. (for both database servers.)

Applications which rely on the the databases work just fine, making changes to the data in the database.

When I try starting a barman backup  on either server it returns:
Starting backup..
Backup start at..
Copying files.
Copy done.
Asking postgresql sever to finalize the backup.
EXCEPTION: Backup failed issuing stop of the backup: FATAL:  the database system is in recovery mode.



iv...@growbots.com

unread,
Apr 27, 2017, 6:18:35 AM4/27/17
to Barman, Backup and Recovery Manager for PostgreSQL
If You are on ubuntu 16.04.x, look into 
RemoveIPC = no
in logind service config.

I have had similar pro
Reply all
Reply to author
Forward
0 new messages