Technology Insights

How to Upgrade PostgreSQL SkyTools walmgr from 2.1.x to 2.1.9

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.
    bash

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

PostgreSQL SkyTools walmgr: Can’t boot Slave: DEBUG Only single loop requested, exiting

I ran into a silly error tonight during some configuration changes for PostgreSQL that took me awhile to figure out so I wanted to share so it might save others some time in the future. In an attempt to boot the slave server in a PostgreSQL SkyTools walmgr configuration I was unable to get it operational. The server would seem like it was stopping recovery mode however I was unable to login and the recovery process was still showing. Eventually I used the verbose switch to see if I could gain more information about why it was not booting up and the output is below.

Command:
walmgr.py conf/wal-slave.ini boot -v

Error:
2009-04-22 01:24:22,949 3899 INFO Stopping recovery mode
2009-04-22 01:24:22,949 3899 DEBUG Using pg_auth file from master.
2009-04-22 01:24:22,950 3899 DEBUG Execute cmd: ‘cp’ ‘/var/lib/pgsql/walshipping/logs.complete/pg_auth’ ‘/var/lib/pgsql/data/global/pg_auth’
2009-04-22 01:24:22,955 3899 DEBUG Only single loop requested, exiting

Details
Technology Insights

Upgrade LiteSpeed Web Server to 4.0.1 from 3.3.24 on Linux

Upgrading LiteSpeed web server from 3.x.x to 4.x.x is easy even though you cannot do so through the web admin console. You are probably used to being able to click the upgrade link in the web admin console and have LiteSpeed do all of the work including having already downloaded the newer release. When upgrading between major versions though you are going to have to put in a little bit more work. Follow the directions below which outline step by step what needs to be done to upgrade LiteSpeed web server from 3.x to 4.x. Below the installation instructions is a more descriptive output of what you will see during the upgrade.

  1. Download New LiteSpeed Version: Logon to your Linux server and change the directory to /usr/local/src to download the 4.x version of LiteSpeed as described below.
    bash

    1. cd /usr/local/src
    2. wget http://www.litespeedtech.com/packages/4.0/lsws-4.0.1-std-i386-linux.tar.gz
Details