dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

On 4 May 2011 14:12, Knut Staring <knutst@xxxxxxxxx> wrote:

> 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.
>
>
Just above that download link is says:
"The PostgreSQL file must be unzipped and can be imported through
pgAdmin restore function or with psql -d dbname -U username -f
dhis2demo.backup" :)

It is not real sql either, but postgres's plain text dump format.

Ola
------



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