Database upgrading: upgrade server first or client first?

From: roy hills <royhills(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Database upgrading: upgrade server first or client first?
Date: 2012-04-30 18:34:15
Message-ID: BAY148-W16254C70CBF23DB488EB9DD9280@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm running a postgresql 8.1 database on a single server which is queried from a number of client systems.
Both server and clients are running Debian Linux.

I need to upgrade from 8.1 to 8.3, but it's difficult for me to upgrade everything at once. Is it possible to
run different versions of the client and server, and if so is it better to upgrade the client first or the server first?

When I say "the client", I mean the psql client and the libpq library (I actually use Perl DBI, but I think that ends
up calling functions in libpq).

My gut feeling is that later versions of the client should detect and work with earlier versions of the server, so
I should upgrade the clients first. But I can't see anything definitive on this.

Any advice or pointers to FAQ items that I've missed would be appreciated.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2012-04-30 18:42:12 Re: Database upgrading: upgrade server first or client first?
Previous Message Liang Ma 2012-04-30 18:34:13 errors on restoring postgresql binary dump to glusterfs