dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

On 29 November 2011 17:30, Jo Størset <897677@xxxxxxxxxxxxxxxxxx> wrote:
> Default encoding of byte arrays have changed between 8.4 and 9.0. It
> should be fixable by specifying bytea_output in the 9 db, see , [1]

Yes this is definitely the cause of at least one of the problems.  Any
idea how you set this on pg_dump though?

Two suggestions I have also seen which may be helpful:
(i) Dump the data separate.  You can restore the schema in an empty
database just by running the latest dhis against it.  Then import the
data from the pg_dump.
(ii) Try to use the 8.4 pg_dump client.

http://stackoverflow.com/questions/4599696/use-pg-restore-to-restore-
from-a-newer-version-of-postgresql


>
> Jo
>
> [1] http://stackoverflow.com/questions/4828266/what-has-changed-between-
> postgres-jdbc-8-4-and-9-regarding-bytearrays
>
> --
> 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