Tom Lane wrote: > Craig James <cjames@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin