From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Tom Lane *EXTERN*" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Craig James" <cjames(at)emolecules(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Mixing 8.4.x and 9.2.x clients and servers |
Date: | 2012-10-10 07:49:13 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C20886ACA8@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Tom Lane wrote:
> Craig James <cjames(at)emolecules(dot)com> writes:
> > Is it OK to mix 9.2.x and 8.4.x clients and servers? Can they talk
to each
> > other? In other words, if I install 9.2 on a new server alongside
older
> > servers running 8.4.x, can clients on the 8.4 systems talk to 9.2
servers,
> > and can the 9.2 clients talk to 8.4 servers?
> In general, sure. There might be some specific incompatibilities (for
> instance, 9.2 clients expecting server features that weren't there in
> 8.4) but the protocol is the same.
One incompatibility that might bite you when an 8.4 client talks to a
9.2 server is the bytea encoding - unless you set "bytea_output" to
"escape" on the server, the client will choke on bytea values.
There are probably other small issues.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2012-10-10 15:57:50 | Re: catalog is missing |
Previous Message | Hariraman Jayaraj | 2012-10-10 05:47:39 | catalog is missing |