postgresql

class pulumi_azure.postgresql.Configuration(resource_name, opts=None, name=None, resource_group_name=None, server_name=None, value=None, __name__=None, __opts__=None)

Sets a PostgreSQL Configuration value on a PostgreSQL Server.

Parameters:
  • resource_name (str) – The name of the resource.
  • opts (pulumi.ResourceOptions) – Options for the resource.
  • name (pulumi.Input[str]) – Specifies the name of the PostgreSQL Configuration, which needs to be a valid PostgreSQL configuration name. Changing this forces a new resource to be created.
  • resource_group_name (pulumi.Input[str]) – The name of the resource group in which the PostgreSQL Server exists. Changing this forces a new resource to be created.
  • server_name (pulumi.Input[str]) – Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.
  • value (pulumi.Input[str]) – Specifies the value of the PostgreSQL Configuration. See the PostgreSQL documentation for valid values.
name = None

Specifies the name of the PostgreSQL Configuration, which needs to be a valid PostgreSQL configuration name. Changing this forces a new resource to be created.

resource_group_name = None

The name of the resource group in which the PostgreSQL Server exists. Changing this forces a new resource to be created.

server_name = None

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

value = None

Specifies the value of the PostgreSQL Configuration. See the PostgreSQL documentation for valid values.

translate_output_property(prop)

Provides subclasses of Resource an opportunity to translate names of output properties into a format of their choosing before writing those properties to the resource object.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
translate_input_property(prop)

Provides subclasses of Resource an opportunity to translate names of input properties into a format of their choosing before sending those properties to the Pulumi engine.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
class pulumi_azure.postgresql.Database(resource_name, opts=None, charset=None, collation=None, name=None, resource_group_name=None, server_name=None, __name__=None, __opts__=None)

Manages a PostgreSQL Database within a PostgreSQL Server

Parameters:
  • resource_name (str) – The name of the resource.
  • opts (pulumi.ResourceOptions) – Options for the resource.
  • charset (pulumi.Input[str]) – Specifies the Charset for the PostgreSQL Database, which needs to be a valid PostgreSQL Charset. Changing this forces a new resource to be created.
  • collation (pulumi.Input[str]) – Specifies the Collation for the PostgreSQL Database, which needs to be a valid PostgreSQL Collation. Note that Microsoft uses different notation - en-US instead of en_US. Changing this forces a new resource to be created.
  • name (pulumi.Input[str]) – Specifies the name of the PostgreSQL Database, which needs to be a valid PostgreSQL identifier. Changing this forces a new resource to be created.
  • resource_group_name (pulumi.Input[str]) – The name of the resource group in which the PostgreSQL Server exists. Changing this forces a new resource to be created.
  • server_name (pulumi.Input[str]) – Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.
charset = None

Specifies the Charset for the PostgreSQL Database, which needs to be a valid PostgreSQL Charset. Changing this forces a new resource to be created.

collation = None

Specifies the Collation for the PostgreSQL Database, which needs to be a valid PostgreSQL Collation. Note that Microsoft uses different notation - en-US instead of en_US. Changing this forces a new resource to be created.

name = None

Specifies the name of the PostgreSQL Database, which needs to be a valid PostgreSQL identifier. Changing this forces a new resource to be created.

resource_group_name = None

The name of the resource group in which the PostgreSQL Server exists. Changing this forces a new resource to be created.

server_name = None

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

translate_output_property(prop)

Provides subclasses of Resource an opportunity to translate names of output properties into a format of their choosing before writing those properties to the resource object.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
translate_input_property(prop)

Provides subclasses of Resource an opportunity to translate names of input properties into a format of their choosing before sending those properties to the Pulumi engine.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
class pulumi_azure.postgresql.FirewallRule(resource_name, opts=None, end_ip_address=None, name=None, resource_group_name=None, server_name=None, start_ip_address=None, __name__=None, __opts__=None)

Manages a Firewall Rule for a PostgreSQL Server

Parameters:
  • resource_name (str) – The name of the resource.
  • opts (pulumi.ResourceOptions) – Options for the resource.
  • end_ip_address (pulumi.Input[str]) – Specifies the End IP Address associated with this Firewall Rule. Changing this forces a new resource to be created.
  • name (pulumi.Input[str]) – Specifies the name of the PostgreSQL Firewall Rule. Changing this forces a new resource to be created.
  • resource_group_name (pulumi.Input[str]) – The name of the resource group in which the PostgreSQL Server exists. Changing this forces a new resource to be created.
  • server_name (pulumi.Input[str]) – Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.
  • start_ip_address (pulumi.Input[str]) – Specifies the Start IP Address associated with this Firewall Rule. Changing this forces a new resource to be created.
end_ip_address = None

Specifies the End IP Address associated with this Firewall Rule. Changing this forces a new resource to be created.

name = None

Specifies the name of the PostgreSQL Firewall Rule. Changing this forces a new resource to be created.

resource_group_name = None

The name of the resource group in which the PostgreSQL Server exists. Changing this forces a new resource to be created.

server_name = None

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

start_ip_address = None

Specifies the Start IP Address associated with this Firewall Rule. Changing this forces a new resource to be created.

translate_output_property(prop)

Provides subclasses of Resource an opportunity to translate names of output properties into a format of their choosing before writing those properties to the resource object.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
translate_input_property(prop)

Provides subclasses of Resource an opportunity to translate names of input properties into a format of their choosing before sending those properties to the Pulumi engine.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
class pulumi_azure.postgresql.Server(resource_name, opts=None, administrator_login=None, administrator_login_password=None, location=None, name=None, resource_group_name=None, sku=None, ssl_enforcement=None, storage_profile=None, tags=None, version=None, __name__=None, __opts__=None)

Manage a PostgreSQL Server.

Parameters:
  • resource_name (str) – The name of the resource.
  • opts (pulumi.ResourceOptions) – Options for the resource.
  • administrator_login (pulumi.Input[str]) – The Administrator Login for the PostgreSQL Server. Changing this forces a new resource to be created.
  • administrator_login_password (pulumi.Input[str]) – The Password associated with the administrator_login for the PostgreSQL Server.
  • location (pulumi.Input[str]) – Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
  • name (pulumi.Input[str]) – Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.
  • resource_group_name (pulumi.Input[str]) – The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.
  • sku (pulumi.Input[dict]) – A sku block as defined below.
  • ssl_enforcement (pulumi.Input[str]) – Specifies if SSL should be enforced on connections. Possible values are Enabled and Disabled.
  • storage_profile (pulumi.Input[dict]) – A storage_profile block as defined below.
  • tags (pulumi.Input[dict]) – A mapping of tags to assign to the resource.
  • version (pulumi.Input[str]) – Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 10.2. Changing this forces a new resource to be created.
administrator_login = None

The Administrator Login for the PostgreSQL Server. Changing this forces a new resource to be created.

administrator_login_password = None

The Password associated with the administrator_login for the PostgreSQL Server.

fqdn = None

The FQDN of the PostgreSQL Server.

location = None

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

name = None

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

resource_group_name = None

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

sku = None

A sku block as defined below.

ssl_enforcement = None

Specifies if SSL should be enforced on connections. Possible values are Enabled and Disabled.

storage_profile = None

A storage_profile block as defined below.

tags = None

A mapping of tags to assign to the resource.

version = None

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 10.2. Changing this forces a new resource to be created.

translate_output_property(prop)

Provides subclasses of Resource an opportunity to translate names of output properties into a format of their choosing before writing those properties to the resource object.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
translate_input_property(prop)

Provides subclasses of Resource an opportunity to translate names of input properties into a format of their choosing before sending those properties to the Pulumi engine.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
class pulumi_azure.postgresql.VirtualNetworkRule(resource_name, opts=None, ignore_missing_vnet_service_endpoint=None, name=None, resource_group_name=None, server_name=None, subnet_id=None, __name__=None, __opts__=None)

Manages a PostgreSQL Virtual Network Rule.

NOTE: PostgreSQL Virtual Network Rules can only be used with SKU Tiers of ``GeneralPurpose` or MemoryOptimized <https://docs.microsoft.com/en-us/azure/postgresql/concepts-data-access-and-security-vnet>`_
Parameters:
  • resource_name (str) – The name of the resource.
  • opts (pulumi.ResourceOptions) – Options for the resource.
  • ignore_missing_vnet_service_endpoint (pulumi.Input[bool]) – Should the Virtual Network Rule be created before the Subnet has the Virtual Network Service Endpoint enabled? Defaults to false.
  • name (pulumi.Input[str]) – The name of the PostgreSQL virtual network rule. Cannot be empty and must only contain alphanumeric characters and hyphens. Cannot start with a number, and cannot start or end with a hyphen. Changing this forces a new resource to be created.
  • resource_group_name (pulumi.Input[str]) – The name of the resource group where the PostgreSQL server resides. Changing this forces a new resource to be created.
  • server_name (pulumi.Input[str]) – The name of the SQL Server to which this PostgreSQL virtual network rule will be applied to. Changing this forces a new resource to be created.
  • subnet_id (pulumi.Input[str]) – The ID of the subnet that the PostgreSQL server will be connected to.
ignore_missing_vnet_service_endpoint = None

Should the Virtual Network Rule be created before the Subnet has the Virtual Network Service Endpoint enabled? Defaults to false.

name = None

The name of the PostgreSQL virtual network rule. Cannot be empty and must only contain alphanumeric characters and hyphens. Cannot start with a number, and cannot start or end with a hyphen. Changing this forces a new resource to be created.

resource_group_name = None

The name of the resource group where the PostgreSQL server resides. Changing this forces a new resource to be created.

server_name = None

The name of the SQL Server to which this PostgreSQL virtual network rule will be applied to. Changing this forces a new resource to be created.

subnet_id = None

The ID of the subnet that the PostgreSQL server will be connected to.

translate_output_property(prop)

Provides subclasses of Resource an opportunity to translate names of output properties into a format of their choosing before writing those properties to the resource object.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str
translate_input_property(prop)

Provides subclasses of Resource an opportunity to translate names of input properties into a format of their choosing before sending those properties to the Pulumi engine.

Parameters:prop (str) – A property name.
Returns:A potentially transformed property name.
Return type:str