DreamApps Wiki

• Stop tomcat and back up data using pg_dumpall

    service tomcat6 stop
    su - postgres
    pg_dumpall > 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/postgresql

• 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

• Create Symbolic Link to ensure back up scripts will work

    ln -s /opt/PostgreSQL/9.3 /var/lib/pgsql