dhis2-devs team mailing list archive

[Jan Henrik Øverland <janhenrik.overland@xxxxxxxxx>]

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


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