Earlier a client with a fairly complex network setup had a power outage in one of their data centers in Dallas, TX. The power outage caused three servers and a firewall to lose power causing all sorts of other issues on the servers themselves. One of the primary issues was getting the PostgreSQL cluster back in 100% operational.
You might receive the below error in your postgresql.log file after issuing the walmgr.py syncdaemon command as explained below.
Error: CDTFATAL: role “root” does not exist
- walmgr.py conf/wal-master.ini syncdaemon -d