Resource Type: Azure > Provider > DB for PostgreSQL

The DB for PostgreSQL provider offers a fully managed relational database service based on the open-source PostgreSQL database engine. This provider enables users to deploy, manage, and scale PostgreSQL databases with built-in high availability, automated backups, and advanced security features, ensuring robust and efficient database management in the cloud.

Resource Context

DB for PostgreSQL is a part of the Provider service.

Each DB for PostgreSQL lives under a Subscription.

Controls

The primary controls for Azure > Provider > DB for PostgreSQL are:

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql

Category URI

tmod:@turbot/turbot#/resource/categories/other

GraphQL

query resource(id: "tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-provider#/resource/types/dbForPostgreSql' and notification_type in ('resource_updated', 'resource_created');