← Back to team overview

dhis2-users team mailing list archive

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

 

There were some issues with the migration so I had to purge the 9.3 and do
a fresh installation of 9.5 and restore my backup. But if the server reboot
I will have to manually do:
pg_ctlcluster 9.5 main start





On Jan 26, 2017 5:59 AM, "Uwe Wahser" <uwe@xxxxxxxxx> wrote:

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