Re: server & client using different version, OK?

Lists: pgsql-admin
From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: server & client using different version, OK?
Date: 2003-11-28 00:14:47
Message-ID: 170990000.1069978487@palle.girgensohn.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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

From: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: server & client using different version, OK?
Date: 2003-11-28 08:48:14
Message-ID: 3FC70BCE.6080301@bluewin.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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(dot)sennhauser(at)bluewin(dot)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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: server & client using different version, OK?
Date: 2003-11-28 17:19:51
Message-ID: 28881.1070039991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Palle Girgensohn <girgen(at)pingpong(dot)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