Thread: server & client using different version, OK?

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

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

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