← Back to team overview

dhis2-devs team mailing list archive

Re: 2.0.5 Postgres sample cannot be restored

 

Should it be called 2.0.5.<revision> based on the branch revision??
Just my 2 cents

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


2010/11/18 Lars Helge Øverland <larshelge@xxxxxxxxx>

> 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