PostgrSQL - Direct Upgrade to Version 9.3

Stop tomcat and back up data using pg_dumpall

service tomcat6 stop
su - postgres
pg_dumpall > /root/mydata.bu
exit
mv /var/lib/pgsql/mydata.bu /root

Go to yast and uninstall postgres

Download PostgreSQL installer from EnterpriseDB and install:

cd /var/lib
wget http://get.enterprisedb.com/postgresql/postgresql-9.3.5-1-linux-x64.run
chmod u+x postgresql-9.3.5-1-linux-x64.run
./postgresql-9.3.5-1-linux-x64.run

Rename service name

mv /etc/init.d/postgresql-9.3 /etc/init.d/posgresql

Using yast set run level 3 & 5 for automatic startup.

Go to bin folder and restore database from backup.

cd /opt/PostgreSQL/9.3/bin
psql -Upostgres < /root/mydata.bu

Restart postgres and start tomcat

service postgresql restart
service tomcat6 start