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