Make local copy of client hostnames in backend status array.

Heikki Linnakangas <heikki.linnakangas@iki.fi>

Commit: dfc383cf3975ccb1053ef7431d1dfdcff1dfefea
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2018-04-11T20:40:31Z
Releases: 9.3.23
Make local copy of client hostnames in backend status array.

The other strings, application_name and query string, were snapshotted to
local memory in pgstat_read_current_status(), but we forgot to do that for
client hostnames. As a result, the client hostname would appear to change in
the local copy, if the client disconnected.

Backpatch to all supported versions.

Author: Edmund Horner
Reviewed-by: Michael Paquier
Discussion: https://www.postgresql.org/message-id/CAMyN-kA7aOJzBmrYFdXcc7Z0NmW%2B5jBaf_m%3D_-77uRNyKC9r%3DA%40mail.gmail.com

Files

PathChange+/−
src/backend/postmaster/pgstat.c modified +7 −0

Discussion