Bob, Thanks it is works!!!!
On 1/26/17, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Gerald it sounds like it has got into a bit of a mess and maybe you risk > just making it worse. It is really not supposed to be this hard, but tit > is next to impossible at a distance to figure out what might have gone > wrong. > > Given that you are not dependent on migrating the cluster, but that you are > simply going to restore your dbs, I would advise that you just try and get > rid of the current non-working postgres installation completely and install > it again. > > sudo apt-get purge postgresql ... etc (check under /etc and /var/lib that > all traces have truly gone) > > On 26 January 2017 at 08:42, gerald thomas <gerald17...@gmail.com> wrote: > >> Mutali, >> I think there was an issue where i have postgresql and postgresql-9.5 >> inside /etc/init.d. But when this command: sudo update-rc.d >> postgresql-9.5 enable >> >> I am getting this message "update-rc.d: warning: >> /etc/init.d/postgresql-9.5 missing LSB information" >> > >> >> On 1/26/17, J. Paul Mutali <mut...@gmail.com> wrote: >> > Hi Gerald, >> > >> > you can use this command: sudo update-rc.d postgresql enable >> > >> > Hope it will work for you. >> > >> > --- >> > >> > JP Mutali >> > >> > Kigali - Rwanda >> > >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas <gerald17...@gmail.com> >> > wrote: >> > >> >> 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" <u...@wahser.de> 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 <gerald17...@gmail.com> 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@lists.launchpad.net >> >> > Unsubscribe : https://launchpad.net/~dhis2-users >> >> > More help : https://help.launchpad.net/ListHelp >> >> >> >> >> >> >> >> >> >> _______________________________________________ >> >> Mailing list: https://launchpad.net/~dhis2-devs >> >> Post to : dhis2-d...@lists.launchpad.net >> >> Unsubscribe : https://launchpad.net/~dhis2-devs >> >> More help : https://help.launchpad.net/ListHelp >> >> >> >> >> > >> >> >> -- >> Regards, >> >> Gerald >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > -- Regards, Gerald _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp