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" :)
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 > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
