A Role represents the declarative state of a PostgreSQL role.
Type
CRD
Group
postgresql.sql.crossplane.io
Version
v1alpha1
apiVersion: postgresql.sql.crossplane.io/v1alpha1
kind: Role
A RoleSpec defines the desired state of a Role.
RoleParameters define the desired state of a PostgreSQL role instance.
ConfigurationParameters to be applied to the role. If specified, any other configuration parameters set on the role in the database will be reset. See https://www.postgresql.org/docs/current/runtime-config-client.html for some available configuration parameters.
Privileges to be granted.
ProviderConfigReference specifies how the provider that will be used to create, observe, update, and delete this managed resource should be configured.
Policies for referencing.
ProviderReference specifies the provider that will be used to create, observe, update, and delete this managed resource. Deprecated: Please use ProviderConfigReference, i.e. providerConfigRef
Policies for referencing.
PublishConnectionDetailsTo specifies the connection secret config which contains a name, metadata and a reference to secret store config to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource.
WriteConnectionSecretToReference specifies the namespace and name of a Secret to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource. This field is planned to be replaced in a future release in favor of PublishConnectionDetailsTo. Currently, both could be set independently and connection details would be published to both without affecting each other.
A RoleStatus represents the observed state of a Role.
A RoleObservation represents the observed state of a PostgreSQL role.
PrivilegesAsClauses represents the applied privileges state, taking into account any defaults applied by Postgres, and expressed as a list of ROLE PRIVILEGE clauses.
Conditions of the resource.
example-role
apiVersion: postgresql.sql.crossplane.io/v1alpha1
kind: Role
metadata:
name: example-role
spec:
forProvider:
privileges:
createDb: true
writeConnectionSecretToRef:
name: example-role-secret
namespace: default
parent-role
apiVersion: postgresql.sql.crossplane.io/v1alpha1
kind: Role
metadata:
name: parent-role
spec:
forProvider:
configurationParameters:
- name: statement_timeout
value: "123"
- name: search_path
value: '"$user",public'
connectionLimit: 10
privileges:
login: true
writeConnectionSecretToRef:
name: example-parent-role-secret
namespace: default
© 2022 Upbound, Inc.
Discover the building blocksfor your internal cloud platform.