dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Postgres is sensitive to minor version changes.

pg_restore --ignore-version will solve your problems in all likelihood.


The command line is you friend. Do not fear it.  pg_restore --help
would have saved a few CPU cycles. :)

Regards,
Jason


On 12/14/09, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:
> 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).
>