Horton

Re: Fix for pg_stat_activity putting client hostaddr into appname field

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Edmund Horner <ejrh00@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>, kuntalghosh.2007@gmail.com
Date: 2018-04-06T02:47:05Z
Lists: pgsql-hackers 
On Fri, Apr 06, 2018 at 10:46:27AM +1200, Edmund Horner wrote:
> Thanks for making a note of it, Michael.  I guess it should be
> considered for the next patch release of v10 too?

The issue is tracked on the wiki, so at least we are sure that we won't
lose sight of it :)

After that, the timing a patch is applied will depend on the time other
folks involved with this code will be able to comment on the patch and
this thread, which may take some time as everybody is busy with closing
the last commit fest for the development cycle of v11.

As far as I can see, this patch should be applied to v10, so my review
may help in pushing forward with it more quickly.  There is also a
couple of weeks ahead until the next minor release which is on the 10th
of May, so there is some room ahead:
https://www.postgresql.org/developer/roadmap/
--
Michael

Commits

  1. Allocate enough shared string memory for stats of auxiliary processes.

  2. Make local copy of client hostnames in backend status array.

  3. Show more processes in pg_stat_activity.