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@xxxxxxxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
