On 29 November 2011 17:30, Jo Størset <897...@bugs.launchpad.net> 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 _______________________________________________ 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
