azure_postgresql_servers resource

Use the azure_postgresql_servers InSpec audit resource to test the properties and configuration of multiple Azure PostgreSQL servers.

Azure REST API version, endpoint, and HTTP client parameters

This resource interacts with API versions supported by the resource provider. You can specify the api_version as a resource parameter to use a specific version of the Azure REST API. If you don’t specify an API version, this resource uses the latest version available. For more information about API versioning, see the azure_generic_resource.

By default, this resource uses the azure_cloud global endpoint and default HTTP client settings. You can override these settings if you need to connect to a different Azure environment (such as Azure Government or Azure China). For more information about configuration options, see the resource pack README.

Syntax

An azure_postgresql_servers resource block returns all Azure PostgreSQL servers within a resource group (if provided) or an entire subscription.

describe azure_postgresql_servers do
  it { should exist }
end

describe azure_postgresql_servers(resource_group: 'RESOURCE_GROUP') do
  it { should exist }
end

Parameters

resource_group (optional): The name of the resource group.

Properties

ids: A list of the unique resource IDs.
Field: id
locations: A list of locations for all the resources being interrogated.
Field: location
names: A list of names of all the resources being interrogated.
Field: name
tags: A list of tag:value pairs defined on the resources.
Field: tags
skus: A list of the SKUs (pricing tiers) of the servers.
Field: sku
types: A list of the types of resources being interrogated.
Field: type
properties: A list of properties for all the resources being interrogated.
Field: properties

Note

For information on using filter criteria on plural resources, see the documentation on FilterTable

Examples

Check a specific PostgreSQL server is present:

describe azure_postgresql_servers do
  its('names')  { should include 'my-server-name' }
end

Filters the results to include only those servers having specified names (client-side filtering):

describe azure_postgresql_servers.where{ name.include?('production') } do
  it { should exist }
end

Filters the results to include only those servers residing in a specified location (client-side filtering):

describe azure_postgresql_servers.where{ location.eql?('westeurope') } do
  it { should exist }
end

Filters the results to include only those servers residing in a specified location and has the specified name (server-side filtering - recommended):

describe azure_generic_resources(resource_provider: 'Microsoft.DBforPostgreSQL/servers', substring_of_name: 'production', location: 'westeurope') do
  it {should exist}
end

Matchers

For a full list of available matchers, see our Universal Matchers page.

This resource has the following special matchers.

exists

The control passes if the filter returns at least one result. Use should_not if you expect zero matches.

describe azure_postgresql_servers do
  it { should exist }
end

Azure permissions

Your Service Principal must be set up with at least a contributor role on the subscription you wish to test.