On 4 May 2011 15:21, Jan Henrik Øverland <[email protected]>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 <[email protected]> wrote: > >> On Wed, May 4, 2011 at 2:21 PM, Ola Hodne Titlestad <[email protected]>wrote: >> >>> >>> On 4 May 2011 14:12, Knut Staring <[email protected]> wrote: >>> >>>> On Wed, May 4, 2011 at 2:01 PM, Jason Pickering < >>>> [email protected]> 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 <[email protected]> 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 : [email protected] >>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Jason P. Pickering >>>>> email: [email protected] >>>>> tel:+260974901293 >>>>> >>>> >>>> >>>> >>>> -- >>>> Cheers, >>>> Knut Staring >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
