pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMixing 8.4.x and 9.2.x clients and servers
3+ messages / 3 participants
[nested] [flat]
* Mixing 8.4.x and 9.2.x clients and servers
@ 2012-10-09 22:11 Craig James <cjames@emolecules.com>
0 siblings, 1 reply; 3+ messages in thread
From: Craig James @ 2012-10-09 22:11 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Mixing 8.4.x and 9.2.x clients and servers
@ 2012-10-09 22:47 Tom Lane <tgl@sss.pgh.pa.us>
parent: Craig James <cjames@emolecules.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2012-10-09 22:47 UTC (permalink / raw)
To: Craig James <cjames@emolecules.com>; +Cc: pgsql-admin
Craig James <cjames@emolecules.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.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Mixing 8.4.x and 9.2.x clients and servers
@ 2012-10-10 07:49 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2012-10-10 07:49 UTC (permalink / raw)
To: Tom Lane *EXTERN* <tgl@sss.pgh.pa.us>; Craig James <cjames@emolecules.com>; +Cc: pgsql-admin
Tom Lane wrote:
> Craig James <cjames@emolecules.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-10-10 07:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-09 22:11 Mixing 8.4.x and 9.2.x clients and servers Craig James <cjames@emolecules.com>
2012-10-09 22:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-10-10 07:49 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox