Skip site navigation (1) Skip section navigation (2)

Re: Upgrade clients when (major) upgrading server?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Chris Bovitz" <Christopher(dot)Bovitz(at)noaa(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrade clients when (major) upgrading server?
Date: 2008-07-24 18:06:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Thu, Jul 24, 2008 at 9:00 AM, Chris Bovitz
<Christopher(dot)Bovitz(at)noaa(dot)gov> wrote:
> 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?

From the perspective of libpq it's not a huge deal, but psql needs to
match to make the \ commands work properly.  Upgrading the client is
pretty simple.  Remove the old client packages and install the new

In response to


pgsql-admin by date

Next:From: Marc FrommDate: 2008-07-24 19:32:54
Subject: restoring from pg_dumpall
Previous:From: Joshua D. DrakeDate: 2008-07-24 18:02:39
Subject: Re: [DOCS] [ADMIN] shared_buffers and shmmax

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group