I have had the same problem as Lars (I dumped on my laptop's 8.4 and couldn't restore on the server's 8.3). But I thought the other way should work - apparently not. You dont in fact need to change the whole server, it is only the pg_restore that needs replacement. I solved my own problem by accessing the server from the PgAdmin on my laptop, thus using the 8.4 restore to restore to add data to the 8.3 database (at least that's what I think I did, it's been some time...)
Knut 2009/12/14 Lars Helge Øverland <[email protected]> > > > On Mon, Dec 14, 2009 at 6:35 PM, Bob Jolliffe <[email protected]>wrote: > >> I seem to have inadvertently upgraded to postgres 8.4 when upgrading to >> ubuntu karmic. Now it seems I cannot read the 8.3 dumpfile: >> pg_restore: [archiver] unsupported version (1.11) in file header >> >> Thats wicked! I'll try and push everything back to 8.3 again. Any of you >> postgres experts got an idea about 8.3/8.4 compatibility? >> >> > That's weird, I recently got a pg backup from Ola which I could not restore > because I was running 8.3 and he 8.4... (I upgraded and it worked). > > _______________________________________________ > 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
