dhis2-devs team mailing list archive

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

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.



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
>