dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

On Wed, May 4, 2011 at 2:21 PM, Ola Hodne Titlestad <olati@xxxxxxxxxx>wrote:

>
> 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" :)
>

Well - sadly it is not possible to create an idiot proof point&click
interface for those of us with such short memory that I didn't even remember
having I asked Lars to correct the filename in that exact command last
week...

Must be getting really old...

k


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


-- 
Cheers,
Knut Staring