Fix handling of escape sequences in postgres_fdw.application_name

Michael Paquier <michael@paquier.xyz>

Commit: 8427ce4c379ee3774b8a9aca13ca7f4bfb76ba85
Author: Michael Paquier <michael@paquier.xyz>
Date: 2023-02-21T11:01:43Z
Releases: 16.0
Fix handling of escape sequences in postgres_fdw.application_name

postgres_fdw.application_name relies on MyProcPort to define the data
that should be added to escape sequences %u (user name) or %d (database
name).  However this code could be run in processes that lack a
MyProcPort, like an autovacuum process, causing crashes.

The code generating the application name is made more flexible with this
commit, so as it now generates no data for %u and %d if MyProcPort is
missing, and a simple "unknown" if MyProcPort exists, but the expected
fields are not set.

Reported-by: Alexander Lakhin
Author: Kyotaro Horiguchi, Michael Paquier
Reviewed-by: Hayato Kuroda, Masahiko Sawada
Discussion: https://postgr.es/m/17789-8b31c5a4672b74d9@postgresql.org
Backpatch-through: 15

Files

PathChange+/−
contrib/postgres_fdw/option.c modified +18 −4

Discussion