PostgreSQL
Public
PostgreSQL loadable plugin
Source
59
59
60
60
**Plugins.PostgreSQL.Sessions.<session_name>.TLSCAFile** — Full pathname of a file containing the top-level CA(s) certificates for PostgreSQL61
61
*Default value:* 62
62
63
63
**Plugins.PostgreSQL.Sessions.<session_name>.TLSCertFile** — Full pathname of a file containing the PostgreSQL certificate or certificate chain.64
64
*Default value:* 65
65
66
66
**Plugins.PostgreSQL.Sessions.*.TLSKeyFile** — Full pathname of a file containing the PostgreSQL private key.67
67
*Default value:* 68
68
69
+
**Plugins.PostgreSQL.Sessions.*.CacheMode** — Cache mode for PostgreSQL connection.70
+
*Default value:* prepare71
+
*Accepted values:* prepare, describe72
+
69
73
### Configuring connection70
74
A connection can be configured using either keys' parameters or named sessions. 71
75
72
76
*Notes*: 73
77
* You can leave any connection parameter empty, a default hard-coded value will be used in the such case.74
78
* TLS information can be passed only from configuration file.75
79
* TLS certificates validation relies on SAN instead of CN, based on https://pkg.go.dev/crypto/x509#Certificate.VerifyHostname76
80
* Embedded URI credentials (userinfo) are forbidden and will be ignored. So, you can't pass the credentials by this: 77
81
78
82
pgsql.ping[tcp://user:password@127.0.0.1/postgres] — WRONG