← Back to team overview

dhis2-devs team mailing list archive

Re: 2.0.5 Postgres sample cannot be restored

 

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.pickering@xxxxxxxxx> 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
> <sunbiz@xxxxxxxxx> 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 <olati@xxxxxxxxxx> 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 <olati@xxxxxxxxxx>
> 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 <sunbiz@xxxxxxxxx>
> >>> 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@xxxxxxxxxxxxxxxxxxx
> >>>> Unsubscribe : https://launchpad.net/~dhis2-devs
> >>>> More help   : https://help.launchpad.net/ListHelp
> >>>>
> >>>
> >>
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
> >
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References