What is the file format? Is it a plain text Postgres dump or has it been created using pg_dump as a compressed dump?
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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
