dhis2-devs team mailing list archive

["jason.p.pickering" <897677@xxxxxxxxxxxxxxxxxx>]

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