libpq: compatibility with server versions
Hi all,
I am using libpq 8.2.4 (and my own wrapper around it) for a
long time now. Due to some performance penalties I would
like to upgrade to 8.4.x libpq.
Is it o.k. if I upgraded my libpq to the newer 8.4
libraries but would still connect to old 8.2 servers?
Are there any compatibility issues to be aware of?
(I am not talking about upgrading the server nor the steps
to take for upgrading the data itself.)
Thank You
Felix
Felix wrote:
I am using libpq 8.2.4 (and my own wrapper around it) for a
long time now. Due to some performance penalties I would
like to upgrade to 8.4.x libpq.Is it o.k. if I upgraded my libpq to the newer 8.4
libraries but would still connect to old 8.2 servers?Are there any compatibility issues to be aware of?
I don't think so.
Yours,
Laurenz Albe
On Sat, Mar 13, 2010 at 4:33 PM, fkater@googlemail.com
<fkater@googlemail.com> wrote:
I am using libpq 8.2.4 (and my own wrapper around it) for a
long time now. Due to some performance penalties I would
like to upgrade to 8.4.x libpq.
What gives you the impression that updating the client library will
improve your performance for anything? I don't see how that would
help at all.
What specific penalties are you getting?
Vick Khera:
On Sat, Mar 13, 2010 at 4:33 PM, fkater@googlemail.com
<fkater@googlemail.com> wrote:I am using libpq 8.2.4 (and my own wrapper around it) for a
long time now. Due to some performance penalties I would
like to upgrade to 8.4.x libpq.What gives you the impression that updating the client library will
improve your performance for anything? I don't see how that would
help at all.
Misunderstanding, sorry: I meant the better performance of
the 8.4 *server* and would like to update libpq therefore as
well. The question was, what however happens if I then need
to connect to older (8.2) servers using the newer (8.4) libpq
libraries.
May I, the other way round, assume from your reply that
there is neither a disadvantage nor a compatibility issue
when I stick to libpq 8.2 (not upgrading to 8.4) but update
the *server* to 8.4?
Felix
On Mon, Mar 15, 2010 at 11:25 AM, fkater@googlemail.com
<fkater@googlemail.com> wrote:
May I, the other way round, assume from your reply that
there is neither a disadvantage nor a compatibility issue
when I stick to libpq 8.2 (not upgrading to 8.4) but update
the *server* to 8.4?
The 8.2 client library will speak just fine to 8.4 server. The client
utilities (such as psql, pg_dump, etc) should match version numbers
for best compatibility.
What I'd do is first upgrade the server to 8.4, then the client. Or
upgrade the client while you're doing your dump/restore to upgrade
from 8.2 to 8.4.