← Back to team overview

dhis2-users team mailing list archive

Re: PostgreSQL-9.5 failed to boot-up at restart of Linux server

 

Hi Gerald,

we did the upgrade while upgrading to Ubuntu 16.04 and everything starts normally. But you have to manually migrate your 9.3 databases into the 9.5 format - did you do that?

These were the bash commands I recorded back then (at your own risk, no guarantee - do backups and all that first)

~/tomcat-dhis/bin/shutdown.sh
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
pg_lsclusters
sudo pg_dropcluster 9.3 main

Hope that helps,

Uwe

---

> gerald thomas <gerald17006@xxxxxxxxx> hat am 26. Januar 2017 um 01:38 geschrieben:
> 
> 
> Dear All,
> We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
> 9.5.5) and it had been successfully done but the Postgres does not
> automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
> start) to start my database but i want it start automatically.
> 
> Please can someone help me?
> 
> -- 
> Regards,
> 
> Gerald
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp


Follow ups

References