← Back to team overview

dhis2-devs team mailing list archive

Re: 2.0.5 Postgres sample cannot be restored

 

2010/11/18 Saptarshi Purkayastha <sunbiz@xxxxxxxxx>

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

I don't think its worth the effort.. We can always get the revision from the
About page..


>
> ---
> 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
>>>
>>
>>
>

References