| From: | roy hills <royhills(at)hotmail(dot)com> |
|---|---|
| To: | <scrawford(at)pinpointresearch(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Database upgrading: upgrade server first or client first? |
| Date: | 2012-05-01 08:12:07 |
| Message-ID: | BAY148-W43357AC72050E2A49E39F8D9290@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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 sessions, a few of the "\" commands don't work with the old
servers
> due to differences in the system tables and similar internal
changes between versions.
Thanks for that. It ties in with what I suspected, and what I've observed in informal tests.
> Also, if putting in the effort to upgrade, consider moving to 9.1 to
get all the current feature and performance benefits.
I'll probably upgrade from 8.3 to 8.4 when I've got 8.3 running and tested. 8.4 is the latest version in the standard Debian Linux package
repository for the latest stable release. But at the moment, I'll just be happy to get 8.3 working, as there have been quite a few changes
between 8.1 and 8.3 which have required changes to the application.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Churcher | 2012-05-01 10:12:29 | Having trouble with pg_dumpall -o |
| Previous Message | Joe Conway | 2012-05-01 04:05:18 | Re: PL/R install, no pgxs available |