dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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
>