diff options
| author | Fujii Masao | 2021-09-07 03:27:30 +0000 |
|---|---|---|
| committer | Fujii Masao | 2021-09-07 03:27:30 +0000 |
| commit | 449ab6350526e99d33363706b759951ebad7928e (patch) | |
| tree | 3ca7c9bca2a856ed389d1a182667581ee6875e4d /doc/src/sgml/postgres-fdw.sgml | |
| parent | 4c3478859b7359912d7e99fea702c56b1f53000c (diff) | |
postgres_fdw: Allow application_name of remote connection to be set via GUC.
This commit adds postgres_fdw.application_name GUC which specifies
a value for application_name configuration parameter used
when postgres_fdw establishes a connection to a foreign server.
This GUC setting always overrides application_name option of
the foreign server object. This GUC is useful when we want to
specify our own application_name per remote connection.
Previously application_name of a remote connection could be set
basically only via options of a server object. But which meant that
every session connecting to the same foreign server basically
should use the same application_name. Also if we want to change
the setting, we had to execute "ALTER SERVER ... OPTIONS ..." command.
It was inconvenient.
Author: Hayato Kuroda
Reviewed-by: Masahiro Ikeda, Fujii Masao
Discussion: https://postgr.es/m/TYCPR01MB5870D1E8B949DAF6D3B84E02F5F29@TYCPR01MB5870.jpnprd01.prod.outlook.com
Diffstat (limited to 'doc/src/sgml/postgres-fdw.sgml')
| -rw-r--r-- | doc/src/sgml/postgres-fdw.sgml | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 0075bc3dbb7..bf95da9721f 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -906,6 +906,31 @@ postgres=# SELECT postgres_fdw_disconnect_all(); </sect2> <sect2> + <title>Configuration Parameters</title> + + <variablelist> + <varlistentry> + <term> + <varname>postgres_fdw.application_name</varname> (<type>string</type>) + <indexterm> + <primary><varname>postgres_fdw.application_name</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Specifies a value for <xref linkend="guc-application-name"/> + configuration parameter used when <filename>postgres_fdw</filename> + establishes a connection to a foreign server. This overrides + <varname>application_name</varname> option of the server object. + Note that change of this parameter doesn't affect any existing + connections until they are re-established. + </para> + </listitem> + </varlistentry> + </variablelist> + </sect2> + + <sect2> <title>Examples</title> <para> |