Re: Application name patch - v4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Subject: Re: Application name patch - v4
Date: 2009-12-02 15:19:33
Message-ID: 13023.1259767173@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Magnus Hagander <magnus(at)hagander(dot)net> writes:
> 2009/12/2 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> BTW, it strikes me that it would only be a matter of a couple of lines
>> to persuade older servers to ignore application_name in the startup
>> packet, instead of throwing a tantrum. Obviously we must make libpq
>> work against unpatched older servers, but if we can save a connection
>> cycle (and some bleating in the postmaster log) when talking to an 8.5
>> application, it might be worth doing:

> Given that this can probably be considered an *extremely* safe patch
> :-), I say go for it. It'll certainly make for less error reports
> around something that's not an error.

Yeah. I wouldn't even propose this, except that given the new code
an unpatched older server will log

FATAL: unrecognized configuration parameter "application_name"

anytime it gets a connection from newer libpq. I'm sure we'll get
some complaints/bugreports about it if we allow that to be the norm.
However, if we backpatch now, there will be relatively few situations
in the field where anyone tries to use 8.5 libpq against an unpatched
older server.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurent Laborde 2009-12-02 15:32:44 Re: Cost of sort/order by not estimated by the query planner
Previous Message Tim Bunce 2009-12-02 15:04:01 Initial refactoring of plperl.c - rebased [PATCH]