PostgreSQL Walshipping Error -- CDTFATAL: role "root" does not exist

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

Command Issued:

walmgr.py conf/wal-master.ini syncdaemon -d

The above command tells the walmgr python script to issue the syncdaemon command using the wal-master.ini configuration file which I have located in /var/lib/pgsql/conf directory. Turns out the error was a silly mistake and it was because I issued the command as root and not the postgres user.

Resolution:Login as postgres user and issue the same command.

After logging in as the correct user the command did not display any other errors in the postgresql.log file. Make sure before you issue the command again that you kill the previous command and remove the walmgr.pid file located in the PostgreSQL root directory which in my case is /var/lib/pgsql directory.