PostgreSQL-9.5 failed to boot-up at restart of Linux server

Support - Assistance technique
1

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

2

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@gmail.com> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

3

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@wahser.de 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

4

Hi Gerald,

you can use this command: sudo update-rc.d postgresql enable

Hope it will work for you.

···

On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas gerald17006@gmail.com 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

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

On Jan 26, 2017 5:59 AM, “Uwe Wahser” uwe@wahser.de 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5

I already tried that and restart server but the issue is the same.

···

On Jan 26, 2017 7:27 AM, “J. Paul Mutali” mutali@gmail.com 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@gmail.com 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

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

On Jan 26, 2017 5:59 AM, “Uwe Wahser” uwe@wahser.de 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@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

6

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@gmail.com> 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@gmail.com> > 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@wahser.de> 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@gmail.com> 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@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

--
Regards,

Gerald

7

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@gmail.com 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@gmail.com 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@gmail.com

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@wahser.de 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@gmail.com 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@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

–

Regards,

Gerald

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

8

Bob,
Thanks it is works!!!!

···

On 1/26/17, Bob Jolliffe <bobjolliffe@gmail.com> 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@gmail.com> 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@gmail.com> 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@gmail.com> >> > 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@wahser.de> 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@gmail.com> 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@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
>>
>>
>

--
Regards,

Gerald

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

--
Regards,

Gerald

9

what works? you removed it and started again?

···

On 26 January 2017 at 10:14, gerald thomas gerald17006@gmail.com wrote:

Bob,

Thanks it is works!!!

On 1/26/17, Bob Jolliffe bobjolliffe@gmail.com 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@gmail.com 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@gmail.com 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@gmail.com

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@wahser.de 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@gmail.com 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@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

–

Regards,

Gerald

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Regards,

Gerald

10

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@gmail.com> wrote:

what works? you removed it and started again?

On 26 January 2017 at 10:14, gerald thomas <gerald17006@gmail.com> wrote:

Bob,
Thanks it is works!!!!

On 1/26/17, Bob Jolliffe <bobjolliffe@gmail.com> 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@gmail.com> >> 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@gmail.com> 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@gmail.com >> > >> >> > 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@wahser.de> 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@gmail.com> 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@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
>> >>
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help : https://help.launchpad.net/ListHelp
>>
>

--
Regards,

Gerald

--
Regards,

Gerald

11

Sounds like now you are really “waist deep in the big muddy”. You have already had to scrap and reinstall your postgres and it looks like your dhis2-tools package is also somehow missing or damaged.

You have your backups. scrap the machine and rebuild. Follow instruction from https://github.com/dhis2/dhis2-tools.

···

On 26 January 2017 at 10:30, gerald thomas gerald17006@gmail.com wrote:

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@gmail.com wrote:

what works? you removed it and started again?

On 26 January 2017 at 10:14, gerald thomas gerald17006@gmail.com wrote:

Bob,

Thanks it is works!!!

On 1/26/17, Bob Jolliffe bobjolliffe@gmail.com 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@gmail.com

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@gmail.com 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@gmail.com

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@wahser.de 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@gmail.com 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@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

–

Regards,

Gerald

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Regards,

Gerald

–

Regards,

Gerald

12

Hi

Gerald managed to get it all up and working again this afternoon + restoring the dump file (onto 9.5.5). So all good now :slight_smile:

Analytics run time dropped from 56 minutes to 17 minutes, which is equivalent to the time it takes on my laptop, so the upgrade was overdue…

Regards

Calle

···

On 26 January 2017 at 12:46, Bob Jolliffe bobjolliffe@gmail.com wrote:

Sounds like now you are really “waist deep in the big muddy”. You have already had to scrap and reinstall your postgres and it looks like your dhis2-tools package is also somehow missing or damaged.

You have your backups. scrap the machine and rebuild. Follow instruction from https://github.com/dhis2/dhis2-tools.

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

–

On 26 January 2017 at 10:30, gerald thomas gerald17006@gmail.com wrote:

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@gmail.com wrote:

what works? you removed it and started again?

On 26 January 2017 at 10:14, gerald thomas gerald17006@gmail.com wrote:

Bob,

Thanks it is works!!!

On 1/26/17, Bob Jolliffe bobjolliffe@gmail.com 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@gmail.com

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@gmail.com 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@gmail.com

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@wahser.de 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@gmail.com 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@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

–

Regards,

Gerald

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Regards,

Gerald

–

Regards,

Gerald

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

13

Thanks to everyone for your support and help during the process though
we are experience what looks to be like bugs but that will be save for
another ticket while we verify and test all the various scenarios
within 2.25.

Once again thanks.

···

On 1/26/17, Calle Hedberg <calle.hedberg@gmail.com> wrote:

Hi

Gerald managed to get it all up and working again this afternoon +
restoring the dump file (onto 9.5.5). So all good now :slight_smile:

Analytics run time dropped from 56 minutes to 17 minutes, which is
equivalent to the time it takes on my laptop, so the upgrade was overdue...

Regards
Calle

On 26 January 2017 at 12:46, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

Sounds like now you are really "waist deep in the big muddy". You have
already had to scrap and reinstall your postgres and it looks like your
dhis2-tools package is also somehow missing or damaged.

You have your backups. scrap the machine and rebuild. Follow
instruction
from https://github.com/dhis2/dhis2-tools\.

On 26 January 2017 at 10:30, gerald thomas <gerald17006@gmail.com> wrote:

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

--
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

--

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg

*******************************************

--
Regards,

Gerald