dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>


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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>
>
> 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
>>
>>
>