what works? you removed it and started again? On 26 January 2017 at 10:14, gerald thomas <[email protected]> wrote:
> Bob, > Thanks it is works!!!! > > > On 1/26/17, Bob Jolliffe <[email protected]> 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 <[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 > >> > > > > > -- > 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
