Re: Mixed Pg-9.1.2 and 8.4.4 environment

On Tue, January 10, 2012 09:28, Adrian Klaver wrote:
> On Tuesday, January 10, 2012 6:17:27 am James B. Byrne
> wrote:
>>
>> My question: Is their a way to specify a pg_dump option
>> to retain compatibility with a lower version pg
>> database?
>> Alternatively, can one install a higher level pg_dump in
>> an otherwise 8.4.4 installation?
>
> Short answer is no. The reason is seen in the errors
> below. EXTENSION does not exist in Postgres below 9.1.
> In this particular case the EXTENSION is being used
> to load a procedural language and that had a pre 9.1
> analog in CREATE LANGUAGE. In other instances that
> would not be the case. pg_dump can dump forward i.e
> use new pg_dump version to pull data forward from old
> Postgres version, but not the other way around.
>

We upgraded the backup systems to v.9.1.2, which was
fairly trivial given that they simply load pgdumps to
begin with.

--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3