Re: [GENERAL] Database upgrading: upgrade server first or client first?

2012-05-01 Thread roy hills
The advice I've received upon asking this question in the past is clients first then server. We are currently running many 9.1 clients against some servers awaiting upgrade - the most ancient of which is 7.4. The only problem (annoyance, really) is that in interactive psql

[GENERAL] Database upgrading: upgrade server first or client first?

2012-04-30 Thread roy hills
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

Re: [GENERAL] Database upgrading: upgrade server first or client first?

2012-04-30 Thread Steve Crawford
On 04/30/2012 11:34 AM, roy hills wrote: 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

Re: [GENERAL] Database upgrading: upgrade server first or client first?

2012-04-30 Thread Andy Colson
On 4/30/2012 1:34 PM, roy hills wrote: 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