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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > > 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" <[email protected]> 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 <[email protected]> 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 : [email protected] > >> > Unsubscribe : https://launchpad.net/~dhis2-users > >> > More help : https://help.launchpad.net/ListHelp > >> > >> > >> > >> > >> _______________________________________________ > >> Mailing list: https://launchpad.net/~dhis2-devs > >> Post to : [email protected] > >> Unsubscribe : https://launchpad.net/~dhis2-devs > >> More help : https://help.launchpad.net/ListHelp > >> > >> > > > > > -- > Regards, > > Gerald > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
