dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

On Wed, May 4, 2011 at 2:01 PM, Jason Pickering <jason.p.pickering@xxxxxxxxx
> wrote:

> What is the file format? Is it a plain text Postgres dump or has it been
> created using pg_dump as a compressed dump?


I am talking about the demo db downloaded from dhis2.org, which has the
suffix .backup but maybe should rather be names .sql for clarity - since
psql is the right tool to restore it.

Knut


> You are right, as you will not be able to (easily) restore a version of the
> database created with Postgres 9 to postgres 8.4. You should be able to
> restore from a plain text dump however.
>
>
>
> On Wed, May 4, 2011 at 1:40 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> Hi,
>>
>> I'm trying this on my server:
>> pg_restore -i -d dhis2_demo -v dhis2demo.backup
>>
>> but all I get is this:
>> pg_restore: [archiver] input file does not appear to be a valid archive
>>
>> Is this likely to be because I still have 8.4 on the server? If so, any
>> tips on upgrading (I have lots of data on the server)?
>>
>> Knut
>>
>>
>>
>> _______________________________________________
>> 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:+260974901293
>



-- 
Cheers,
Knut Staring