Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 7AF056503F0
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 24 Jul 2008 13:04:26 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 16732-03-2 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 24 Jul 2008 13:04:13 -0300 (ADT)
X-Greylist: delayed 01:00:07.617617 by SQLgrey-1.7.6
Received: from mmp1.nems.noaa.gov (mmp1.nems.noaa.gov [140.90.121.156])
	by postgresql.org (Postfix) with ESMTP id 879C065037C
	for <pgsql-admin@postgresql.org>; Thu, 24 Jul 2008 13:00:07 -0300 (ADT)
Received: from [10.1.10.145] ([192.46.108.142])
	by mmp1.nems.noaa.gov (Sun Java System Messaging Server 6.2-2.05 (built
	Apr 28
	2005)) with ESMTPSA id <0K4I00GN7MZZTS70@mmp1.nems.noaa.gov> for
	pgsql-admin@postgresql.org; Thu, 24 Jul 2008 11:00:00 -0400 (EDT)
Date: Thu, 24 Jul 2008 10:00:00 -0500
From: Chris Bovitz <Christopher.Bovitz@noaa.gov>
Subject: Upgrade clients when (major) upgrading server?
To: pgsql-admin@postgresql.org
Message-id: <488898F0.6010406@noaa.gov>
Organization: NOAA/NWS/NOHRSC
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Thunderbird 2.0.0.16 (X11/20080707)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200807/206
X-Sequence-Number: 29816

We have 8.1.3 on our operational and development database servers and 
will upgrade to 8.3.3 (development) and 8.2.9 (operations) soon.  (We 
will not upgrade both systems' databases now because we've already 
tested 8.2 on our web server database for the past year, so it's already 
spent time in "development.")  I have read through the server upgrade 
notes, and they seem to be pretty self-explanatory.  It's even mentioned 
how to upgrade the client.  And that's where my questions lie.

The clients on our workstations were installed when our 8.1.3 was 
installed, which I was not involved with.  When I do "psql --version" on 
a client machine, it says "8.0.3".  When I do this on the server, I get 
"8.1.3".

Do we need to upgrade the clients?  Should we?  If so to which version?  
What is involved with that?  That is, other than the note in the 
upgrade/installation man pages, is there a set of instructions for 
upgrading the client-side software?  If we don't have to upgrade now, 
when would we have to?  Are there any things to watch for I should be 
aware of?

Thanks.


Chris