dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Not sure if I would recommend upgrading to 11.04 which is almost out
of service life.

12.04LTS edition will be supported till beyond 2017 so that is what
you need to have your eye on.  It has been announced that 9.1 will be
packaged with that.

If you want to do an unofficial upgrade to postgres 9.1 on ubuntu
10.04LTS you can check out the backports here:
https://launchpad.net/~pitti/+archive/postgresql

Martin Pitt is the ubuntu technical lead on postgresql so I guess his
ppa should be good enough.

Mind you if you are going to do this I think I would uninstall
postgres 8.4 first or you are going to end up with two postgres
databases listening on different ports which can be confusing.

Bob

On 29 November 2011 17:15, jason.p.pickering <897677@xxxxxxxxxxxxxxxxxx> wrote:
> Or upgrade to Ububtu 11.04 where postgres 9.1 is included as a package.
> On Nov 29, 2011 7:10 PM, "Bob Jolliffe" <bobjolliffe@xxxxxxxxx> wrote:
>
>> I've succeeded in restoring postgres 8.4 from 9.0 a couple of times
>> but I can see there is indeed a syntax incompatibility here.
>>
>> Moving to 9.1 on Ubuntu 10.04LTS is not really my recommended option
>> as 9.1 is not in the standard repositories.  Which is why I have been
>> advising people to stick with 8.4 until the new LTS comes out next
>> year.  But seems we like to live on the bleeding edge :-)
>>
>> Ife if you can send me a dump I can see if there is anything can be
>> done to massage it into 8.4.  Otherwise you are going to have to set
>> about installing 9.1 on your ubuntu server by adding a custom
>> repository for the postgres version.
>>
>> Cheers
>> Bob
>>
>> On 29 November 2011 13:50, jason.p.pickering <897677@xxxxxxxxxxxxxxxxxx>
>> wrote:
>> > I do not think this is an issue with DHIS2, but an issue restoring
>> > from Postgres 9.1 to Postgres 8.4. Postgres is normally quite
>> > sensitive about backwards restores, i.e. from 9.1 to 8.4. Going from
>> > 8.4 to 9.1 should not be a problem but the other way around may
>> > present issues, which I think is the problem with one of the error
>> > screen shots you sent.
>> >
>> >
>> > On Tue, Nov 29, 2011 at 3:27 PM, Ifeanyi Okoye
>> > <897677@xxxxxxxxxxxxxxxxxx> wrote:
>> >> Public bug reported:
>> >>
>> >> I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my
>> Windows 7 computer. I used pg_dump to create a database backup in plain
>> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
>> server. The restore was successful but there were some errors.
>> >> After logging in, we found that there were problems with the following
>> functions:
>> >>
>> >> 1. Some of the settings did not import with the database restore
>> >> 2. Opening system general settings throws an exception
>> >> 3. Adding users also throws an exception
>> >> 4. Trying to edit a dataset throws exceptions as well.
>> >>
>> >> I have attached some error logs and screenshots for you to see
>> >>
>> >> ** Affects: dhis2
>> >>     Importance: Undecided
>> >>         Status: New
>> >>
>> >> --
>> >> You received this bug notification because you are a member of DHIS 2
>> >> India Developers, which is subscribed to DHIS.
>> >> https://bugs.launchpad.net/bugs/897677
>> >>
>> >> Title:
>> >>  Some functions not working in DHIS 2 after database restore
>> >>
>> >> Status in DHIS 2 - District Health Information Software:
>> >>  New
>> >>
>> >> Bug description:
>> >>  I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on
>> my Windows 7 computer. I used pg_dump to create a database backup in plain
>> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
>> server. The restore was successful but there were some errors.
>> >>  After logging in, we found that there were problems with the following
>> functions:
>> >>
>> >>  1. Some of the settings did not import with the database restore
>> >>  2. Opening system general settings throws an exception
>> >>  3. Adding users also throws an exception
>> >>  4. Trying to edit a dataset throws exceptions as well.
>> >>
>> >>  I have attached some error logs and screenshots for you to see
>> >>
>> >> To manage notifications about this bug go to:
>> >> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>> >>
>> >
>> > --
>> > You received this bug notification because you are a member of DHIS 2
>> > India Developers, which is subscribed to DHIS.
>> > https://bugs.launchpad.net/bugs/897677
>> >
>> > Title:
>> >  Some functions not working in DHIS 2 after database restore
>> >
>> > Status in DHIS 2 - District Health Information Software:
>> >  New
>> >
>> > Bug description:
>> >  I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my
>> Windows 7 computer. I used pg_dump to create a database backup in plain
>> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
>> server. The restore was successful but there were some errors.
>> >  After logging in, we found that there were problems with the following
>> functions:
>> >
>> >  1. Some of the settings did not import with the database restore
>> >  2. Opening system general settings throws an exception
>> >  3. Adding users also throws an exception
>> >  4. Trying to edit a dataset throws exceptions as well.
>> >
>> >  I have attached some error logs and screenshots for you to see
>> >
>> > To manage notifications about this bug go to:
>> > https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>> >
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> India Developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/897677
>>
>> Title:
>>  Some functions not working in DHIS 2 after database restore
>>
>> Status in DHIS 2 - District Health Information Software:
>>  New
>>
>> Bug description:
>>  I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my
>> Windows 7 computer. I used pg_dump to create a database backup in plain
>> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
>> server. The restore was successful but there were some errors.
>>  After logging in, we found that there were problems with the following
>> functions:
>>
>>  1. Some of the settings did not import with the database restore
>>  2. Opening system general settings throws an exception
>>  3. Adding users also throws an exception
>>  4. Trying to edit a dataset throws exceptions as well.
>>
>>  I have attached some error logs and screenshots for you to see
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>>
>
> --
> You received this bug notification because you are a member of DHIS 2
> India Developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/897677
>
> Title:
>  Some functions not working in DHIS 2 after database restore
>
> Status in DHIS 2 - District Health Information Software:
>  New
>
> Bug description:
>  I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my Windows 7 computer. I used pg_dump to create a database backup in plain format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 server. The restore was successful but there were some errors.
>  After logging in, we found that there were problems with the following functions:
>
>  1. Some of the settings did not import with the database restore
>  2. Opening system general settings throws an exception
>  3. Adding users also throws an exception
>  4. Trying to edit a dataset throws exceptions as well.
>
>  I have attached some error logs and screenshots for you to see
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/897677

Title:
  Some functions not working in DHIS 2 after database restore

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my Windows 7 computer. I used pg_dump to create a database backup in plain format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 server. The restore was successful but there were some errors. 
  After logging in, we found that there were problems with the following functions:
   
  1. Some of the settings did not import with the database restore
  2. Opening system general settings throws an exception
  3. Adding users also throws an exception
  4. Trying to edit a dataset throws exceptions as well.

  I have attached some error logs and screenshots for you to see

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions