W3cubDocs

/Ansible

azure.azcollection.azure_rm_postgresqlflexibleadministrator module – Manage PostgreSQL Flexible Administrator instance

Note

This module is part of the azure.azcollection collection (version 3.7.0).

You might already have this collection installed if you are using the ansible package. It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it, use: ansible-galaxy collection install azure.azcollection. You need further requirements to be able to use this module, see Requirements for details.

To use it in a playbook, specify: azure.azcollection.azure_rm_postgresqlflexibleadministrator.

New in azure.azcollection 3.6.0

Synopsis
Requirements
Parameters
Notes
See Also
Examples
Return Values

Synopsis

Add or Delete instance of PostgreSQL Flexible Administrator.
Require the postflexible server Enable Microsoft Entra authenticate.

Requirements

The below requirements are needed on the host that executes this module.

python >= 2.7
The host that executes this module must have the azure.azcollection collection installed via galaxy
All python packages listed in collection’s requirements.txt must be installed via pip on the host that executes modules from azure.azcollection
Full installation instructions may be found https://galaxy.ansible.com/azure/azcollection

Parameters

Parameter	Comments
ad_user string	Active Directory username. Use when authenticating with an Active Directory user rather than service principal.
adfs_authority_url string added in azure.azcollection 0.0.1	Azure AD authority url. Use when authenticating with Username/password, and has your own ADFS authority.
api_profile string added in azure.azcollection 0.0.1	Selects an API profile to use when communicating with Azure services. Default value of `latest` is appropriate for public clouds; future values will allow use with Azure Stack. Default: `"latest"`
auth_source string added in azure.azcollection 0.0.1	Controls the source of the credentials to use for authentication. Can also be set via the `ANSIBLE_AZURE_AUTH_SOURCE` environment variable. When set to `auto` (the default) the precedence is module parameters -> `env` -> `credential_file` -> `cli`. When set to `env`, the credentials will be read from the environment variables When set to `credential_file`, it will read the profile from `~/.azure/credentials`. When set to `cli`, the credentials will be sources from the Azure CLI profile. `subscription_id` or the environment variable `AZURE_SUBSCRIPTION_ID` can be used to identify the subscription ID if more than one is present otherwise the default az cli subscription is used. When set to `msi`, the host machine must be an azure resource with an enabled MSI extension. `subscription_id` or the environment variable `AZURE_SUBSCRIPTION_ID` can be used to identify the subscription ID if the resource is granted access to more than one subscription, otherwise the first subscription is chosen. The `msi` was added in Ansible 2.6. Choices: `"auto"` ← (default) `"cli"` `"credential_file"` `"env"` `"msi"`
cert_validation_mode string added in azure.azcollection 0.0.1	Controls the certificate validation behavior for Azure endpoints. By default, all modules will validate the server certificate, but when an HTTPS proxy is in use, or against Azure Stack, it may be necessary to disable this behavior by passing `ignore`. Can also be set via credential file profile or the `AZURE_CERT_VALIDATION` environment variable. Choices: `"ignore"` `"validate"`
client_id string	Azure client ID. Use when authenticating with a Service Principal or Managed Identity (msi). Can also be set via the `AZURE_CLIENT_ID` environment variable.
cloud_environment string added in azure.azcollection 0.0.1	For cloud environments other than the US public cloud, the environment name (as defined by Azure Python SDK, eg, `AzureChinaCloud`, `AzureUSGovernment`), or a metadata discovery endpoint URL (required for Azure Stack). Can also be set via credential file profile or the `AZURE_CLOUD_ENVIRONMENT` environment variable. Default: `"AzureCloud"`
disable_instance_discovery boolean added in azure.azcollection 2.3.0	Determines whether or not instance discovery is performed when attempting to authenticate. Setting this to true will completely disable both instance discovery and authority validation. This functionality is intended for use in scenarios where the metadata endpoint cannot be reached such as in private clouds or Azure Stack. The process of instance discovery entails retrieving authority metadata from https://login.microsoft.com/ to validate the authority. By setting this to True, the validation of the authority is disabled. As a result, it is crucial to ensure that the configured authority host is valid and trustworthy. Set via credential file profile or the `AZURE_DISABLE_INSTANCE_DISCOVERY` environment variable. Choices: `false` ← (default) `true`
log_mode string	Parent argument.
log_path string	Parent argument.
object_id string / required	The Object ID of Azure Directory Administrator.
password string	Active Directory user password. Use when authenticating with an Active Directory user rather than service principal.
principal_name string	Active Directory administrator principal name.
principal_type string	The principal type used to represent the type of Active Directory Administrator. Choices: `"Unknown"` `"User"` `"Group"` `"ServicePrincipal"`
profile string	Security profile found in ~/.azure/credentials file.
resource_group string / required	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
secret string	Azure client secret. Use when authenticating with a Service Principal.
server_name string / required	The name of the post gresql flexible server.
state string	Assert the state of the PostgreSQL Flexible administrator. Use `present` to create or update a administrator and `absent` to delete it. Choices: `"absent"` `"present"` ← (default)
subscription_id string	Your Azure subscription Id.
tenant string	Azure tenant ID. Use when authenticating with a Service Principal.
tenant_id string	The tenant ID of Active Directory Administrator.
thumbprint string added in azure.azcollection 1.14.0	The thumbprint of the private key specified in x509_certificate_path. Use when authenticating with a Service Principal. Required if x509_certificate_path is defined.
x509_certificate_path path added in azure.azcollection 1.14.0	Path to the X509 certificate used to create the service principal in PEM format. The certificate must be appended to the private key. Use when authenticating with a Service Principal.

Notes

Note

For authentication with Azure you can pass parameters, set environment variables, use a profile stored in ~/.azure/credentials, or log in before you run your tasks or playbook with az login.
Authentication is also possible using a service principal or Active Directory user.
To authenticate via service principal, pass subscription_id, client_id, secret and tenant or set environment variables AZURE_SUBSCRIPTION_ID, AZURE_CLIENT_ID, AZURE_SECRET and AZURE_TENANT.
To authenticate via Active Directory user, pass ad_user and password, or set AZURE_AD_USER and AZURE_PASSWORD in the environment.
Alternatively, credentials can be stored in ~/.azure/credentials. This is an ini file containing a [default] section and the following keys: subscription_id, client_id, secret and tenant or subscription_id, ad_user and password. It is also possible to add additional profiles. Specify the profile by passing profile or setting AZURE_PROFILE in the environment.

Examples

- name: Create (or update) PostgreSQL Flexible Administrator
  azure_rm_postgresqlflexibleadministrator:
    resource_group: myResourceGroup
    server_name: testserver
    object_id: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
    principal_type: User
    principal_name: fred-sun
    tenant_id: yyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy

- name: Delete PostgreSQL Flexible Administrator
  azure_rm_postgresqlflexibleadministrator:
    resource_group: myResourceGroup
    server_name: testserver
    object_id: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
    state: absent

Return Values

Common return values are documented here, the following are the fields unique to this module:

Key	Description
administrator complex	A list of dictionaries containing facts for PostgreSQL Flexible Administrator. Returned: always
id string	Resource ID of the postgresql flexible admistrator. Returned: always Sample: `"/subscriptions/xxx-xxx/resourceGroups/testRG/providers/Microsoft.DBforPostgreSQL/flexibleServers/postgresql03/administrators/xxx-xxx"`
object_id string	The Object ID of Azure Directory Administrator. Returned: always Sample: `"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"`
principal_name string	Active Directory administrator principal name. Returned: always Sample: `"fred-sun"`
principal_type string	The principal type used to represent the type of Active Directory Administrator. Returned: always Sample: `"User"`
resource_group string	The resource group name. Returned: always Sample: `"testRG"`
server_name string	The type of the resource. Returned: always Sample: `"postgresql03"`
tenant_id string	The tenant ID of Active Directory Administrator. Returned: always Sample: `"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx"`
type string	The type of the resource. Returned: always Sample: `"Microsoft.DBforPostgreSQL/flexibleServers/administrators"`

Authors

magodo (@magodo)
xuzhang3 (@xuzhang3)
Fred-sun (@Fred-sun)

Collection links

© 2012–2018 Michael DeHaan
© 2018–2025 Red Hat, Inc.
Licensed under the GNU General Public License version 3.
https://docs.ansible.com/ansible/latest/collections/azure/azcollection/azure_rm_postgresqlflexibleadministrator_module.html