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
