dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

2009/12/14 Jason Pickering <jason.p.pickering@xxxxxxxxx>

> 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 <knutst@xxxxxxxxx> 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 <larshelge@xxxxxxxxx>
> >
> >>
> >>
> >> On Mon, Dec 14, 2009 at 6:35 PM, Bob Jolliffe
> >> <bobjolliffe@xxxxxxxxx>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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
> >
> > --
> > Cheers,
> > Knut Staring
> >
>



-- 
Cheers,
Knut Staring