← Back to team overview

dhis2-devs team mailing list archive

Re: [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 Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
> what works?  you removed it and started again?
>
> On 26 January 2017 at 10:14, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>
>> Bob,
>> Thanks it is works!!!!
>>
>>
>> On 1/26/17, Bob Jolliffe <bobjolliffe@xxxxxxxxx> 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 <gerald17006@xxxxxxxxx>
>> 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 <mutali@xxxxxxxxx> 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
>> >> > <gerald17006@xxxxxxxxx
>> >
>> >> > 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" <uwe@xxxxxxxxx> 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 <gerald17006@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> >> >> > Unsubscribe : https://launchpad.net/~dhis2-users
>> >> >> > More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> _______________________________________________
>> >> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> >> 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@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald


Follow ups

References