Thread: server & client using different version, OK?

server & client using different version, OK?

From
Palle Girgensohn
Date:
Hi!

Just a quickie:

Surely, I can use an postgresql 7.2 client to connect to a 7.3.x or 7.4
server, right? Or are there any changes made between 7.2 and higher that
will make older clients fail?

Regard,
Palle



Re: server & client using different version, OK?

From
Oli Sennhauser
Date:
Hello Palle

Under oracle we generally recommended to use newer client version
against older database versions (downwards compatibility is more often
given than upwards). But I do not know what is official recommendation
for PostgreSQL.

Regards Oli

-------------------------------------------------------

Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland

Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail oli.sennhauser@bluewin.ch

Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch

Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import


Attachment

Re: server & client using different version, OK?

From
Tom Lane
Date:
Palle Girgensohn <girgen@pingpong.net> writes:
> Surely, I can use an postgresql 7.2 client to connect to a 7.3.x or 7.4
> server, right?

It will work unless the client makes now-obsolete assumptions about the
layout of the system catalogs.

As an example, a 7.2 psql will work for issuing regular user queries
against a newer server, but its catalog inquiry stuff (\d and friends)
will work poorly or not at all.

            regards, tom lane