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

2017-01-25 Thread gerald thomas 
I already tried that and restart server but the issue is the same.

On Jan 26, 2017 7:27 AM, "J. Paul Mutali"  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 
> 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"  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  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-us...@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
>>
>>
>
>
>
>
___
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

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

2017-01-25 Thread J. Paul Mutali 
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 
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"  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  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-us...@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
>
>
___
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

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

2017-01-25 Thread gerald thomas 
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"  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  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-us...@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

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

2017-01-25 Thread Uwe Wahser 
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  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-us...@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

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

2017-01-25 Thread gerald thomas 
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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp