1. Packages
  2. Packages
  3. Tencentcloud Provider
  4. API Docs
  5. getPostgresqlDbInstanceSecurityGroups
Viewing docs for tencentcloud 1.83.23
published on Friday, Aug 14, 2026 by tencentcloudstack
Viewing docs for tencentcloud 1.83.23
published on Friday, Aug 14, 2026 by tencentcloudstack

    Use this data source to query security groups associated with TencentCloud PostgreSQL instance or read-only group.

    Example Usage

    Query security groups associated with a PostgreSQL instance

    import * as pulumi from "@pulumi/pulumi";
    import * as tencentcloud from "@pulumi/tencentcloud";
    
    const example = tencentcloud.getPostgresqlDbInstanceSecurityGroups({
        dbInstanceId: "postgres-ckwcgdf1",
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    example = tencentcloud.get_postgresql_db_instance_security_groups(db_instance_id="postgres-ckwcgdf1")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := tencentcloud.GetPostgresqlDbInstanceSecurityGroups(ctx, &tencentcloud.GetPostgresqlDbInstanceSecurityGroupsArgs{
    			DbInstanceId: pulumi.StringRef("postgres-ckwcgdf1"),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Tencentcloud = Pulumi.Tencentcloud;
    
    return await Deployment.RunAsync(() => 
    {
        var example = Tencentcloud.GetPostgresqlDbInstanceSecurityGroups.Invoke(new()
        {
            DbInstanceId = "postgres-ckwcgdf1",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.TencentcloudFunctions;
    import com.pulumi.tencentcloud.inputs.GetPostgresqlDbInstanceSecurityGroupsArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var example = TencentcloudFunctions.getPostgresqlDbInstanceSecurityGroups(GetPostgresqlDbInstanceSecurityGroupsArgs.builder()
                .dbInstanceId("postgres-ckwcgdf1")
                .build());
    
        }
    }
    
    variables:
      example:
        fn::invoke:
          function: tencentcloud:getPostgresqlDbInstanceSecurityGroups
          arguments:
            dbInstanceId: postgres-ckwcgdf1
    
    Example coming soon!
    

    Query security groups associated with a read-only group

    import * as pulumi from "@pulumi/pulumi";
    import * as tencentcloud from "@pulumi/tencentcloud";
    
    const example = tencentcloud.getPostgresqlDbInstanceSecurityGroups({
        readOnlyGroupId: "pgrogrp-6fexzcmy",
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    example = tencentcloud.get_postgresql_db_instance_security_groups(read_only_group_id="pgrogrp-6fexzcmy")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := tencentcloud.GetPostgresqlDbInstanceSecurityGroups(ctx, &tencentcloud.GetPostgresqlDbInstanceSecurityGroupsArgs{
    			ReadOnlyGroupId: pulumi.StringRef("pgrogrp-6fexzcmy"),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Tencentcloud = Pulumi.Tencentcloud;
    
    return await Deployment.RunAsync(() => 
    {
        var example = Tencentcloud.GetPostgresqlDbInstanceSecurityGroups.Invoke(new()
        {
            ReadOnlyGroupId = "pgrogrp-6fexzcmy",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.TencentcloudFunctions;
    import com.pulumi.tencentcloud.inputs.GetPostgresqlDbInstanceSecurityGroupsArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var example = TencentcloudFunctions.getPostgresqlDbInstanceSecurityGroups(GetPostgresqlDbInstanceSecurityGroupsArgs.builder()
                .readOnlyGroupId("pgrogrp-6fexzcmy")
                .build());
    
        }
    }
    
    variables:
      example:
        fn::invoke:
          function: tencentcloud:getPostgresqlDbInstanceSecurityGroups
          arguments:
            readOnlyGroupId: pgrogrp-6fexzcmy
    
    Example coming soon!
    

    Using getPostgresqlDbInstanceSecurityGroups

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getPostgresqlDbInstanceSecurityGroups(args: GetPostgresqlDbInstanceSecurityGroupsArgs, opts?: InvokeOptions): Promise<GetPostgresqlDbInstanceSecurityGroupsResult>
    function getPostgresqlDbInstanceSecurityGroupsOutput(args: GetPostgresqlDbInstanceSecurityGroupsOutputArgs, opts?: InvokeOptions): Output<GetPostgresqlDbInstanceSecurityGroupsResult>
    def get_postgresql_db_instance_security_groups(db_instance_id: Optional[str] = None,
                                                   id: Optional[str] = None,
                                                   read_only_group_id: Optional[str] = None,
                                                   result_output_file: Optional[str] = None,
                                                   opts: Optional[InvokeOptions] = None) -> GetPostgresqlDbInstanceSecurityGroupsResult
    def get_postgresql_db_instance_security_groups_output(db_instance_id: pulumi.Input[Optional[str]] = None,
                                                   id: pulumi.Input[Optional[str]] = None,
                                                   read_only_group_id: pulumi.Input[Optional[str]] = None,
                                                   result_output_file: pulumi.Input[Optional[str]] = None,
                                                   opts: Optional[InvokeOptions] = None) -> Output[GetPostgresqlDbInstanceSecurityGroupsResult]
    func GetPostgresqlDbInstanceSecurityGroups(ctx *Context, args *GetPostgresqlDbInstanceSecurityGroupsArgs, opts ...InvokeOption) (*GetPostgresqlDbInstanceSecurityGroupsResult, error)
    func GetPostgresqlDbInstanceSecurityGroupsOutput(ctx *Context, args *GetPostgresqlDbInstanceSecurityGroupsOutputArgs, opts ...InvokeOption) GetPostgresqlDbInstanceSecurityGroupsResultOutput

    > Note: This function is named GetPostgresqlDbInstanceSecurityGroups in the Go SDK.

    public static class GetPostgresqlDbInstanceSecurityGroups 
    {
        public static Task<GetPostgresqlDbInstanceSecurityGroupsResult> InvokeAsync(GetPostgresqlDbInstanceSecurityGroupsArgs args, InvokeOptions? opts = null)
        public static Output<GetPostgresqlDbInstanceSecurityGroupsResult> Invoke(GetPostgresqlDbInstanceSecurityGroupsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetPostgresqlDbInstanceSecurityGroupsResult> getPostgresqlDbInstanceSecurityGroups(GetPostgresqlDbInstanceSecurityGroupsArgs args, InvokeOptions options)
    public static Output<GetPostgresqlDbInstanceSecurityGroupsResult> getPostgresqlDbInstanceSecurityGroups(GetPostgresqlDbInstanceSecurityGroupsArgs args, InvokeOptions options)
    
    fn::invoke:
      function: tencentcloud:index/getPostgresqlDbInstanceSecurityGroups:getPostgresqlDbInstanceSecurityGroups
      arguments:
        # arguments dictionary
    data "tencentcloud_get_postgresql_db_instance_security_groups" "name" {
        # arguments
    }

    The following arguments are supported:

    DbInstanceId string
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    Id string
    ReadOnlyGroupId string
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    ResultOutputFile string
    Used to save results.
    DbInstanceId string
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    Id string
    ReadOnlyGroupId string
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    ResultOutputFile string
    Used to save results.
    db_instance_id string
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    id string
    read_only_group_id string
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    result_output_file string
    Used to save results.
    dbInstanceId String
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    id String
    readOnlyGroupId String
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    resultOutputFile String
    Used to save results.
    dbInstanceId string
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    id string
    readOnlyGroupId string
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    resultOutputFile string
    Used to save results.
    db_instance_id str
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    id str
    read_only_group_id str
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    result_output_file str
    Used to save results.
    dbInstanceId String
    Instance ID, which can be obtained via the DescribeDBInstances API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the instance, only pass the DBInstanceId field.
    id String
    readOnlyGroupId String
    Read-only group ID, which can be obtained via the DescribeReadOnlyGroups API. DBInstanceId, ReadOnlyGroupId at least pass one; if you want to query the security group associated with the read-only group, only pass the ReadOnlyGroupId.
    resultOutputFile String
    Used to save results.

    getPostgresqlDbInstanceSecurityGroups Result

    The following output properties are available:

    id string
    security_group_sets list(object)
    Security group information list of the instance.
    db_instance_id string
    read_only_group_id string
    result_output_file string
    id String
    securityGroupSets List<Property Map>
    Security group information list of the instance.
    dbInstanceId String
    readOnlyGroupId String
    resultOutputFile String

    Supporting Types

    GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSet

    CreateTime string
    Creation time.
    Inbounds []GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSetInbound
    Inbound rule.
    Outbounds []GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSetOutbound
    Outbound rule.
    ProjectId float64
    Project ID.
    SecurityGroupDescription string
    Security group remark.
    SecurityGroupId string
    Security group ID.
    SecurityGroupName string
    Security group name.
    create_time string
    Creation time.
    inbounds list(object)
    Inbound rule.
    outbounds list(object)
    Outbound rule.
    project_id number
    Project ID.
    security_group_description string
    Security group remark.
    security_group_id string
    Security group ID.
    security_group_name string
    Security group name.
    createTime string
    Creation time.
    inbounds GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSetInbound[]
    Inbound rule.
    outbounds GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSetOutbound[]
    Outbound rule.
    projectId number
    Project ID.
    securityGroupDescription string
    Security group remark.
    securityGroupId string
    Security group ID.
    securityGroupName string
    Security group name.
    createTime String
    Creation time.
    inbounds List<Property Map>
    Inbound rule.
    outbounds List<Property Map>
    Outbound rule.
    projectId Number
    Project ID.
    securityGroupDescription String
    Security group remark.
    securityGroupId String
    Security group ID.
    securityGroupName String
    Security group name.

    GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSetInbound

    Action string
    Policy, ACCEPT or DROP.
    CidrIp string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    Description string
    Rule description.
    IpProtocol string
    Network protocol, supports UDP, TCP, etc.
    PortRange string
    Port.
    Action string
    Policy, ACCEPT or DROP.
    CidrIp string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    Description string
    Rule description.
    IpProtocol string
    Network protocol, supports UDP, TCP, etc.
    PortRange string
    Port.
    action string
    Policy, ACCEPT or DROP.
    cidr_ip string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description string
    Rule description.
    ip_protocol string
    Network protocol, supports UDP, TCP, etc.
    port_range string
    Port.
    action String
    Policy, ACCEPT or DROP.
    cidrIp String
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description String
    Rule description.
    ipProtocol String
    Network protocol, supports UDP, TCP, etc.
    portRange String
    Port.
    action string
    Policy, ACCEPT or DROP.
    cidrIp string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description string
    Rule description.
    ipProtocol string
    Network protocol, supports UDP, TCP, etc.
    portRange string
    Port.
    action str
    Policy, ACCEPT or DROP.
    cidr_ip str
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description str
    Rule description.
    ip_protocol str
    Network protocol, supports UDP, TCP, etc.
    port_range str
    Port.
    action String
    Policy, ACCEPT or DROP.
    cidrIp String
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description String
    Rule description.
    ipProtocol String
    Network protocol, supports UDP, TCP, etc.
    portRange String
    Port.

    GetPostgresqlDbInstanceSecurityGroupsSecurityGroupSetOutbound

    Action string
    Policy, ACCEPT or DROP.
    CidrIp string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    Description string
    Rule description.
    IpProtocol string
    Network protocol, supports UDP, TCP, etc.
    PortRange string
    Port.
    Action string
    Policy, ACCEPT or DROP.
    CidrIp string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    Description string
    Rule description.
    IpProtocol string
    Network protocol, supports UDP, TCP, etc.
    PortRange string
    Port.
    action string
    Policy, ACCEPT or DROP.
    cidr_ip string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description string
    Rule description.
    ip_protocol string
    Network protocol, supports UDP, TCP, etc.
    port_range string
    Port.
    action String
    Policy, ACCEPT or DROP.
    cidrIp String
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description String
    Rule description.
    ipProtocol String
    Network protocol, supports UDP, TCP, etc.
    portRange String
    Port.
    action string
    Policy, ACCEPT or DROP.
    cidrIp string
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description string
    Rule description.
    ipProtocol string
    Network protocol, supports UDP, TCP, etc.
    portRange string
    Port.
    action str
    Policy, ACCEPT or DROP.
    cidr_ip str
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description str
    Rule description.
    ip_protocol str
    Network protocol, supports UDP, TCP, etc.
    port_range str
    Port.
    action String
    Policy, ACCEPT or DROP.
    cidrIp String
    Source or destination IP or IP range, e.g. 172.16.0.0/12.
    description String
    Rule description.
    ipProtocol String
    Network protocol, supports UDP, TCP, etc.
    portRange String
    Port.

    Package Details

    Repository
    tencentcloud tencentcloudstack/terraform-provider-tencentcloud
    License
    Notes
    This Pulumi package is based on the tencentcloud Terraform Provider.
    Viewing docs for tencentcloud 1.83.23
    published on Friday, Aug 14, 2026 by tencentcloudstack

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial