For the record, both 2.0.5 and trunk has been updated with latest postgres jdbc driver.
The WAR file on dhis2.org is updated regularly as minor bugs/updates are done: http://dhis2.org/download/dhis2-2.0.5.war Lars On Thu, Nov 11, 2010 at 9:48 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Just replaced my Postgres JDBC driver with > http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar > and this error does not seem to happen. I can enter the GIS and modify > user settings. > > Seems there is level of incompatibility between the version currently > included with 2.0.5 and Postgres 9. > > Regards, > Jason > > > On Thu, Nov 11, 2010 at 12:59 AM, Saptarshi Purkayastha > <sun...@gmail.com> wrote: > > Like I wrote in the first email, the command line restore works fine, but > > then gives the exception > > Then after I clear the usersetting table, the exception goes away. > > Adding a new report to view in the dashboard (i.e. changes the > usersetting) > > again throws the exception... Until cleared again, keeps throwing the > > exception! > > --- > > Regards, > > Saptarshi PURKAYASTHA > > > > My Tech Blog: http://sunnytalkstech.blogspot.com > > You Live by CHOICE, Not by CHANCE > > > > > > On 10 November 2010 23:43, Ola Hodne Titlestad <ol...@ifi.uio.no> wrote: > >> > >> Hi, > >> Sorry, what I meant to say is that you should try to load/import this > dump > >> file using the psql command and not pg_restore (which pgAdmin uses). > >> Try: > >> $psql -q -h localhost -p 5432 -U dhis -W test_db < test.sql > >> > >> > >> ---------------------------------- > >> Ola Hodne Titlestad (Mr) > >> HISP > >> Department of Informatics > >> University of Oslo > >> > >> Mobile: +47 48069736 > >> Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link > >> > >> > >> On 10 November 2010 23:27, Ola Hodne Titlestad <ol...@ifi.uio.no> > wrote: > >>> > >>> Saptarshi, > >>> The file on dhis2.org is a plain text sql dump, despite the name > .backup, > >>> and not a compressed pgadmin backup. I haven't tried to restore that in > >>> pgadmin, but there might be a problem with that, not sure. > >>> Have you tried to restore this plain text dump from the command line? > >>> A compressed backup of the same database is available here: > >>> http://folk.uio.no/olati/filer/dhis2demo-pg-2.0.5_compressed.backup > >>> Ola, > >>> > >>> ---------------------------------- > >>> Ola Hodne Titlestad (Mr) > >>> HISP > >>> Department of Informatics > >>> University of Oslo > >>> > >>> Mobile: +47 48069736 > >>> Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link > >>> > >>> > >>> On 10 November 2010 14:50, Saptarshi Purkayastha <sun...@gmail.com> > >>> wrote: > >>>> > >>>> Hi devs, > >>>> The sample database backup for 2.0.5 at > >>>> http://dhis2.org/downloads cannot be restored using pgadmin > >>>> When using pgadmin the 'OK' button stays gray. I've tried this and > some > >>>> say that plan backups cannot be restored, compressed ones work fine > >>>> Also after the command-line restore gives the following exception on > >>>> login: > >>>> > >>>> Exception (org.hibernate.type.SerializationException): could not > >>>> deserialize > >>>> > >>>> Caused by (java.io.StreamCorruptedException): invalid stream header: > >>>> BB656430 > >>>> > >>>> --- > >>>> Regards, > >>>> Saptarshi PURKAYASTHA > >>>> > >>>> My Tech Blog: http://sunnytalkstech.blogspot.com > >>>> You Live by CHOICE, Not by CHANCE > >>>> > >>>> _______________________________________________ > >>>> 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 > > > > > > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+260968395190 > > _______________________________________________ > 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
