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 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
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 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
[Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server
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-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp