← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server

 

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


Follow ups

References