Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
Thanks to everyone for your support and help during the process though we are experience what looks to be like bugs but that will be save for another ticket while we verify and test all the various scenarios within 2.25. Once again thanks. On 1/26/17, Calle Hedbergwrote: > Hi > > Gerald managed to get it all up and working again this afternoon + > restoring the dump file (onto 9.5.5). So all good now :-) > > Analytics run time dropped from 56 minutes to 17 minutes, which is > equivalent to the time it takes on my laptop, so the upgrade was overdue... > > Regards > Calle > > On 26 January 2017 at 12:46, Bob Jolliffe wrote: > >> Sounds like now you are really "waist deep in the big muddy". You have >> already had to scrap and reinstall your postgres and it looks like your >> dhis2-tools package is also somehow missing or damaged. >> >> You have your backups. scrap the machine and rebuild. Follow >> instruction >> from https://github.com/dhis2/dhis2-tools. >> >> On 26 January 2017 at 10:30, gerald thomas wrote: >> >>> Yes Bob, >>> But i now i am having a major issue because i can't find the >>> dhis2-startup, dhis2-stop or dhis2-status but the profile of the >>> instance is available. >>> >>> >>> >>> On 1/26/17, Bob Jolliffe wrote: >>> > what works? you removed it and started again? >>> > >>> > On 26 January 2017 at 10:14, gerald thomas >>> wrote: >>> > >>> >> Bob, >>> >> Thanks it is works >>> >> >>> >> >>> >> On 1/26/17, Bob Jolliffe 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 >>> >> 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 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 >>> >> >> > >> >> > >>> >> >> > 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" 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 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 >>> >> >>
Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
Hi Gerald managed to get it all up and working again this afternoon + restoring the dump file (onto 9.5.5). So all good now :-) Analytics run time dropped from 56 minutes to 17 minutes, which is equivalent to the time it takes on my laptop, so the upgrade was overdue... Regards Calle On 26 January 2017 at 12:46, Bob Jolliffewrote: > Sounds like now you are really "waist deep in the big muddy". You have > already had to scrap and reinstall your postgres and it looks like your > dhis2-tools package is also somehow missing or damaged. > > You have your backups. scrap the machine and rebuild. Follow instruction > from https://github.com/dhis2/dhis2-tools. > > On 26 January 2017 at 10:30, gerald thomas wrote: > >> Yes Bob, >> But i now i am having a major issue because i can't find the >> dhis2-startup, dhis2-stop or dhis2-status but the profile of the >> instance is available. >> >> >> >> On 1/26/17, Bob Jolliffe wrote: >> > what works? you removed it and started again? >> > >> > On 26 January 2017 at 10:14, gerald thomas >> wrote: >> > >> >> Bob, >> >> Thanks it is works >> >> >> >> >> >> On 1/26/17, Bob Jolliffe 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 >> >> 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 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 >> >> >> > > >> > >> >> >> > 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" 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 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-us...@lists.launchpad.net >> >>
Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
Yes Bob, But i now i am having a major issue because i can't find the dhis2-startup, dhis2-stop or dhis2-status but the profile of the instance is available. On 1/26/17, Bob Jolliffewrote: > what works? you removed it and started again? > > On 26 January 2017 at 10:14, gerald thomas wrote: > >> Bob, >> Thanks it is works >> >> >> On 1/26/17, Bob Jolliffe 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 >> 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 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 >> >> > > > >> >> > 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" 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 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-us...@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-devs@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-us...@lists.launchpad.net >> >> Unsubscribe : https://launchpad.net/~dhis2-users >> >> More help : https://help.launchpad.net/ListHelp >> >> >> > >> >> >> -- >> Regards, >> >> Gerald >> > -- Regards, Gerald ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
Bob, Thanks it is works On 1/26/17, Bob Jolliffewrote: > 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 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 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 >> > 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" 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 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-us...@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-devs@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-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > -- Regards, Gerald ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
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 thomaswrote: > 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 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 > > 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" 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 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-us...@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-devs@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-us...@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-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
I already tried that and restart server but the issue is the same. On Jan 26, 2017 7:27 AM, "J. Paul Mutali"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 > 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" 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 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-us...@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-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server
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 thomaswrote: > 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" 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 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-us...@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-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] 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"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 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-us...@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-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [Dhis2-users] 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 thomashat 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-us...@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-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp