Upgrading walmgr.py is easy since really this is just a python script. The most complicated part of the upgrade process will be keeping your database cluster up. Follow the below steps and you should avoid any downtime.

1. Download Latest SkyTools: Visit PgFoundry to download the latest SkyTools. Issue the below command from /usr/local/src on each server.

   wget http://pgfoundry.org/frs/download.php/2129/skytools-2.1.9.tar.gz
   

Read the rest of this entry »

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

Read the rest of this entry »