servers

Creates, updates, deletes, gets or lists a servers resource.

Overview

Name	servers
Type	Resource
Id	azure.postgresql_hsc.servers

Fields

vw_servers

Name	Datatype	Description
administrator_login	text	field from the properties object
availability_zone	text	field from the properties object
citus_version	text	field from the properties object
clusterName	text	field from the properties object
enable_ha	text	field from the properties object
enable_public_ip_access	text	field from the properties object
fully_qualified_domain_name	text	field from the properties object
ha_state	text	field from the properties object
is_read_only	text	field from the properties object
postgresql_version	text	field from the properties object
resourceGroupName	text	field from the properties object
role	text	field from the properties object
serverName	text	field from the properties object
server_edition	text	field from the properties object
state	text	field from the properties object
storage_quota_in_mb	text	field from the properties object
subscriptionId	text	field from the properties object
v_cores	text	field from the properties object

servers

Name	Datatype	Description
properties	object	The properties of a server in cluster.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	clusterName, resourceGroupName, serverName, subscriptionId	Gets information about a server in cluster.
list_by_cluster	SELECT	clusterName, resourceGroupName, subscriptionId	Lists servers of a cluster.

SELECT examples

Lists servers of a cluster.

vw_servers

SELECT
administrator_login,
availability_zone,
citus_version,
clusterName,
enable_ha,
enable_public_ip_access,
fully_qualified_domain_name,
ha_state,
is_read_only,
postgresql_version,
resourceGroupName,
role,
serverName,
server_edition,
state,
storage_quota_in_mb,
subscriptionId,
v_cores
FROM azure.postgresql_hsc.vw_servers
WHERE clusterName = '{{ clusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

servers

SELECT
properties
FROM azure.postgresql_hsc.servers
WHERE clusterName = '{{ clusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';