dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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
>