dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

On 4 May 2011 15:21, Jan Henrik Øverland <janhenrik.overland@xxxxxxxxx>wrote:

> Just to clear up - pgAdmin can export:
>
>    - BACKUP
>       - compressed backup
>       - imported by pgAdmin restore, not by the psql command
>       - called .backup
>
>       - TAR
>       - SQL
>       - imported by pgAdmin restore, not by the psql command
>
>       - PLAIN
>       - postgres' plain text dump format like Ola said, the same as using
>       the *pg_dump* command
>       - imported by the *psql* command, can *not* be imported by pgAdmin
>       restore
>       - should *not* be called .backup, but .pgdump or .pgplain etc
>
>
>
Thanks Jan Henrik.

Ola
-----



> On Wed, May 4, 2011 at 14:33, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> 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
>>
>> _______________________________________________
>> 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
>>
>>
>