Mixed Pg-9.1.2 and 8.4.4 environment

From: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Mixed Pg-9.1.2 and 8.4.4 environment
Date: 2012-01-10 14:17:27
Message-ID: 46798.216.185.71.25.1326205047.squirrel@webmail.harte-lyne.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are in the process of migrating our various servers to
a kvm host with guest vms. The new guests run pg-9.1.2
under CentOS-6.2. However, our off site warm spares are
still running pg-8.4.4 under CentOS-5.7.

We have an automated transfer routine that dumps the live
database, now running v.9.1.2, and sends the dump file to
the off site host. There the dump is restored to an 8.4.4
version.

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?

The reason for the question is that we are receiving these
warnings:

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 257; 3079
12506 EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query:
ERROR: syntax error at or near "EXTENSION"
LINE 1: DROP EXTENSION plpgsql;
^
Command was: DROP EXTENSION plpgsql;
pg_restore: [archiver (db)] could not execute query:
ERROR: syntax error at or near "EXTENSION"
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA
pg_catalo...
^
Command was: CREATE EXTENSION IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog;
pg_restore: [archiver (db)] Error from TOC entry 3473; 0 0
COMMENT EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query:
ERROR: syntax error at or near "EXTENSION"
LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL
procedural languag...
^
Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL
procedural language';
pg_restore: [archiver (db)] Error from TOC entry 3462; 0
20928 TABLE DATA wiki_content_versions
hll_redmine_db_admin
pg_restore: [archiver (db)] COPY failed: ERROR: invalid
input syntax for type bytea
CONTEXT: COPY wiki_content_versions, line 1, column data:
"\x68312e205b5b57696b6953746172747c48617274652026204c796e65204c696d697465642053746172745d5d0d0a0d0a0d..."
WARNING: errors ignored on restore: 4

--
*** 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-01-10 14:28:26 Re: Mixed Pg-9.1.2 and 8.4.4 environment
Previous Message Craig Ringer 2012-01-10 13:50:14 Re: Time to move table to new tablespace