Re: clients and libs and versions (oh my)

Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> When version mismatches between the client and server are inevitable,
> what is less likely to get me into trouble - clients/libs newer than
> server or server newer than clients/libs?

For the most part I'd update the server first; the exception is that
you'd better be running a pg_dump at least as new as the server.

Also, psql's \d commands are pretty version-specific and frequently fail
if the server is either up-rev or down-rev.

Whichever order you do it in (and most of the time it's probably not
that critical), I'd try to avoid really serious gaps in versions.
7.3 client against 8.1 server, or vice versa, is likely to be a
headache. We do try to maintain cross-version compatibility, but
over more than a couple of releases the gotchas will accumulate.

regards, tom lane