83 lines
3.1 KiB
YAML
83 lines
3.1 KiB
YAML
# yaml-language-server: $schema=../../component-metadata-schema.json
|
|
schemaVersion: v1
|
|
type: configuration
|
|
name: postgresql
|
|
version: v1
|
|
status: stable
|
|
title: "PostgreSQL"
|
|
urls:
|
|
- title: Reference
|
|
url: https://docs.dapr.io/reference/components-reference/supported-configuration-stores/postgresql-configuration-store/
|
|
capabilities: []
|
|
builtinAuthenticationProfiles:
|
|
- name: "azuread"
|
|
metadata:
|
|
- name: useAzureAD
|
|
required: true
|
|
type: bool
|
|
example: '"true"'
|
|
description: |
|
|
Must be set to `true` to enable the component to retrieve access tokens from Azure AD.
|
|
This authentication method only works with Azure Database for PostgreSQL databases.
|
|
- name: connectionString
|
|
required: true
|
|
sensitive: true
|
|
description: |
|
|
The connection string for the PostgreSQL database
|
|
This must contain the user, which corresponds to the name of the user created inside PostgreSQL that maps to the Azure AD identity; this is often the name of the corresponding principal (e.g. the name of the Azure AD application). This connection string should not contain any password.
|
|
example: |
|
|
"host=mydb.postgres.database.azure.com user=myapplication port=5432 database=dapr_test sslmode=require"
|
|
type: string
|
|
authenticationProfiles:
|
|
- title: "Connection string"
|
|
description: "Authenticate using a Connection String."
|
|
metadata:
|
|
- name: connectionString
|
|
required: true
|
|
sensitive: true
|
|
description: The connection string for the PostgreSQL database
|
|
example: |
|
|
"host=localhost user=postgres password=example port=5432 connect_timeout=10 database=dapr_test"
|
|
type: string
|
|
metadata:
|
|
- name: table
|
|
required: true
|
|
description: The table name for configuration information.
|
|
example: "configTable"
|
|
type: string
|
|
- name: connectionMaxIdleTime
|
|
required: false
|
|
description: |
|
|
Max idle time before unused connections are automatically closed in the
|
|
connection pool. By default, there's no value and this is left to the
|
|
database driver to choose.
|
|
example: "5m"
|
|
type: duration
|
|
- name: maxConns
|
|
required: false
|
|
description: |
|
|
Maximum number of connections pooled by this component.
|
|
Set to 0 or lower to use the default value, which is the greater of 4 or the number of CPUs.
|
|
example: "4"
|
|
default: "0"
|
|
type: number
|
|
- name: connMaxIdleTime
|
|
deprecated: true
|
|
required: false
|
|
description: |
|
|
Deprecated alias for 'connectionMaxIdleTime'.
|
|
example: "5m"
|
|
type: duration
|
|
- name: queryExecMode
|
|
required: false
|
|
description: |
|
|
Controls the default mode for executing queries. By default Dapr uses the extended protocol and automatically prepares and caches prepared statements.
|
|
However, this may be incompatible with proxies such as PGBouncer. In this case it may be preferrable to use `exec` or `simple_protocol`.
|
|
allowedValues:
|
|
- "cache_statement"
|
|
- "cache_describe"
|
|
- "describe_exec"
|
|
- "exec"
|
|
- "simple_protocol"
|
|
example: "cache_describe"
|
|
default: "" |