2009/12/14 Jason Pickering <[email protected]> > This is really not a good idea. There can be changes between minor > versions, this is why Postgres is picky. Using a different version of > pg_restore with a different Postgres database could be a recipe for > disaster. >
> Having said this. DHIS utilizes essentially no custom aspects of > postgres, so differences between minor versionf of postgres "should" > present no issues, but there is no guarentee. > Agree that it is not ideal, but it did work fine in this case. > As usual, unless there is a reason to upgrade a production database > package, it probably is not a good idea to do so, just because a new > one has been released unless it is thoroughly tested. > Yeah, but in general people will always install the newest version, just like Bob inadvertently had, and I don't think it makes sense for us to require everyone to use 8.3, for the reasons you state above (we dont use any specific features, and --ignore-versions seems to work). Knut > > > > On 12/14/09, Knut Staring <[email protected]> wrote: > > 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 > > > -- 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
