Uninstall and Install Postgresql 8.3

sudo apt-get --purge remove postgresql | apt-get install postgresql-8.3

Errors faced:

Setting up postgresql-8.3 (8.3.5-0ubuntu8.10) ...
* Starting PostgreSQL 8.3 database server * Insecure directory in $ENV{PATH} while running with -T switch at /usr/share/postgresql-common/PgCommon.pm line 654. [fail]

invoke-rc.d: initscript postgresql-8.3, action "start" failed. dpkg: error processing postgresql-8.3 (--configure): subprocess post-installation script returned error exit status 255  Errors were encountered while processing: postgresql-8.3

Resolution:

• sudo dpkg –configure –a
• sudo apt-get install –f
• sudo apt-get update

If the issue still persists, do the following.

• sudo nano /usr/share/postgresql-common/PgCommon.pm and on the first top line , remove the –T from that line.
• sudo apt-get –purge remove postgresql

Now if you try to do sudo apt-get install postgresql-8.3 it should work fine.