diff options
| author | Fujii Masao <fujii@postgresql.org> | 2022-02-18 11:38:12 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2022-02-18 11:38:12 +0900 |
| commit | 94c49d53402240ad7ddbcae9049ff2840a54b9c6 (patch) | |
| tree | bff534c8386626a4278a2dd9ac743ae3a50dc351 /doc/src | |
| parent | c476f380e296bab57fecada1ea96c86d575bf160 (diff) | |
| download | postgresql-94c49d53402240ad7ddbcae9049ff2840a54b9c6.tar.gz postgresql-94c49d53402240ad7ddbcae9049ff2840a54b9c6.zip | |
postgres_fdw: Make postgres_fdw.application_name support more escape sequences.
Commit 6e0cb3dec1 allowed postgres_fdw.application_name to include
escape sequences %a (application name), %d (database name), %u (user name)
and %p (pid). In addition to them, this commit makes it support
the escape sequences for session ID (%c) and cluster name (%C).
These are helpful to investigate where each remote transactions came from.
Author: Fujii Masao
Reviewed-by: Ryohei Takahashi, Kyotaro Horiguchi
Discussion: https://postgr.es/m/1041dc9a-c976-049f-9f14-e7d94c29c4b2@oss.nttdata.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/postgres-fdw.sgml | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 7bb6e525a46..dc57fe4b0d1 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -985,6 +985,20 @@ postgres=# SELECT postgres_fdw_disconnect_all(); <entry>Application name on local server</entry> </row> <row> + <entry><literal>%c</literal></entry> + <entry> + Session ID on local server + (see <xref linkend="guc-log-line-prefix"/> for details) + </entry> + </row> + <row> + <entry><literal>%C</literal></entry> + <entry> + Cluster name in local server + (see <xref linkend="guc-cluster-name"/> for details) + </entry> + </row> + <row> <entry><literal>%u</literal></entry> <entry>User name on local server</entry> </row> |