Mixing 8.4.x and 9.2.x clients and servers

[Craig James]

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?

Thanks,
Craig

[Tom Lane]

Post by Craig James
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.

regards, tom lane

[Albe Laurenz]

Post by Tom Lane

Post by Craig James
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