1. Packages
  2. OVH
  3. API Docs
  4. CloudProjectDatabase
  5. getDatabasePostgreSQLConnectionPools
OVHCloud v2.9.0 published on Friday, Nov 7, 2025 by OVHcloud
ovh logo
OVHCloud v2.9.0 published on Friday, Nov 7, 2025 by OVHcloud

    Use this data source to get the list of connection pools of a postgresql cluster associated with a public cloud project.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as ovh from "@ovhcloud/pulumi-ovh";
    
    const testPools = ovh.CloudProjectDatabase.getDatabasePostgreSQLConnectionPools({
        serviceName: "XXX",
        clusterId: "YYY",
    });
    export const connectionPoolIds = testPools.then(testPools => testPools.connectionPoolIds);
    
    import pulumi
    import pulumi_ovh as ovh
    
    test_pools = ovh.CloudProjectDatabase.get_database_postgre_sql_connection_pools(service_name="XXX",
        cluster_id="YYY")
    pulumi.export("connectionPoolIds", test_pools.connection_pool_ids)
    
    package main
    
    import (
    	"github.com/ovh/pulumi-ovh/sdk/v2/go/ovh/cloudprojectdatabase"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		testPools, err := cloudprojectdatabase.GetDatabasePostgreSQLConnectionPools(ctx, &cloudprojectdatabase.GetDatabasePostgreSQLConnectionPoolsArgs{
    			ServiceName: "XXX",
    			ClusterId:   "YYY",
    		}, nil)
    		if err != nil {
    			return err
    		}
    		ctx.Export("connectionPoolIds", testPools.ConnectionPoolIds)
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Ovh = Pulumi.Ovh;
    
    return await Deployment.RunAsync(() => 
    {
        var testPools = Ovh.CloudProjectDatabase.GetDatabasePostgreSQLConnectionPools.Invoke(new()
        {
            ServiceName = "XXX",
            ClusterId = "YYY",
        });
    
        return new Dictionary<string, object?>
        {
            ["connectionPoolIds"] = testPools.Apply(getDatabasePostgreSQLConnectionPoolsResult => getDatabasePostgreSQLConnectionPoolsResult.ConnectionPoolIds),
        };
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.ovh.CloudProjectDatabase.CloudProjectDatabaseFunctions;
    import com.pulumi.ovh.CloudProjectDatabase.inputs.GetDatabasePostgreSQLConnectionPoolsArgs;
    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 testPools = CloudProjectDatabaseFunctions.getDatabasePostgreSQLConnectionPools(GetDatabasePostgreSQLConnectionPoolsArgs.builder()
                .serviceName("XXX")
                .clusterId("YYY")
                .build());
    
            ctx.export("connectionPoolIds", testPools.connectionPoolIds());
        }
    }
    
    variables:
      testPools:
        fn::invoke:
          function: ovh:CloudProjectDatabase:getDatabasePostgreSQLConnectionPools
          arguments:
            serviceName: XXX
            clusterId: YYY
    outputs:
      connectionPoolIds: ${testPools.connectionPoolIds}
    

    Using getDatabasePostgreSQLConnectionPools

    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 getDatabasePostgreSQLConnectionPools(args: GetDatabasePostgreSQLConnectionPoolsArgs, opts?: InvokeOptions): Promise<GetDatabasePostgreSQLConnectionPoolsResult>
    function getDatabasePostgreSQLConnectionPoolsOutput(args: GetDatabasePostgreSQLConnectionPoolsOutputArgs, opts?: InvokeOptions): Output<GetDatabasePostgreSQLConnectionPoolsResult>
    def get_database_postgre_sql_connection_pools(cluster_id: Optional[str] = None,
                                                  service_name: Optional[str] = None,
                                                  opts: Optional[InvokeOptions] = None) -> GetDatabasePostgreSQLConnectionPoolsResult
    def get_database_postgre_sql_connection_pools_output(cluster_id: Optional[pulumi.Input[str]] = None,
                                                  service_name: Optional[pulumi.Input[str]] = None,
                                                  opts: Optional[InvokeOptions] = None) -> Output[GetDatabasePostgreSQLConnectionPoolsResult]
    func GetDatabasePostgreSQLConnectionPools(ctx *Context, args *GetDatabasePostgreSQLConnectionPoolsArgs, opts ...InvokeOption) (*GetDatabasePostgreSQLConnectionPoolsResult, error)
    func GetDatabasePostgreSQLConnectionPoolsOutput(ctx *Context, args *GetDatabasePostgreSQLConnectionPoolsOutputArgs, opts ...InvokeOption) GetDatabasePostgreSQLConnectionPoolsResultOutput

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

    public static class GetDatabasePostgreSQLConnectionPools 
    {
        public static Task<GetDatabasePostgreSQLConnectionPoolsResult> InvokeAsync(GetDatabasePostgreSQLConnectionPoolsArgs args, InvokeOptions? opts = null)
        public static Output<GetDatabasePostgreSQLConnectionPoolsResult> Invoke(GetDatabasePostgreSQLConnectionPoolsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDatabasePostgreSQLConnectionPoolsResult> getDatabasePostgreSQLConnectionPools(GetDatabasePostgreSQLConnectionPoolsArgs args, InvokeOptions options)
    public static Output<GetDatabasePostgreSQLConnectionPoolsResult> getDatabasePostgreSQLConnectionPools(GetDatabasePostgreSQLConnectionPoolsArgs args, InvokeOptions options)
    
    fn::invoke:
      function: ovh:CloudProjectDatabase/getDatabasePostgreSQLConnectionPools:getDatabasePostgreSQLConnectionPools
      arguments:
        # arguments dictionary

    The following arguments are supported:

    ClusterId string
    Cluster ID.
    ServiceName string
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    ClusterId string
    Cluster ID.
    ServiceName string
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    clusterId String
    Cluster ID.
    serviceName String
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    clusterId string
    Cluster ID.
    serviceName string
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    cluster_id str
    Cluster ID.
    service_name str
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    clusterId String
    Cluster ID.
    serviceName String
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.

    getDatabasePostgreSQLConnectionPools Result

    The following output properties are available:

    ClusterId string
    See Argument Reference above.
    ConnectionPoolIds List<string>
    The list of patterns ids of the opensearch cluster associated with the project.
    Id string
    The provider-assigned unique ID for this managed resource.
    ServiceName string
    See Argument Reference above.
    ClusterId string
    See Argument Reference above.
    ConnectionPoolIds []string
    The list of patterns ids of the opensearch cluster associated with the project.
    Id string
    The provider-assigned unique ID for this managed resource.
    ServiceName string
    See Argument Reference above.
    clusterId String
    See Argument Reference above.
    connectionPoolIds List<String>
    The list of patterns ids of the opensearch cluster associated with the project.
    id String
    The provider-assigned unique ID for this managed resource.
    serviceName String
    See Argument Reference above.
    clusterId string
    See Argument Reference above.
    connectionPoolIds string[]
    The list of patterns ids of the opensearch cluster associated with the project.
    id string
    The provider-assigned unique ID for this managed resource.
    serviceName string
    See Argument Reference above.
    cluster_id str
    See Argument Reference above.
    connection_pool_ids Sequence[str]
    The list of patterns ids of the opensearch cluster associated with the project.
    id str
    The provider-assigned unique ID for this managed resource.
    service_name str
    See Argument Reference above.
    clusterId String
    See Argument Reference above.
    connectionPoolIds List<String>
    The list of patterns ids of the opensearch cluster associated with the project.
    id String
    The provider-assigned unique ID for this managed resource.
    serviceName String
    See Argument Reference above.

    Package Details

    Repository
    ovh ovh/pulumi-ovh
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the ovh Terraform Provider.
    ovh logo
    OVHCloud v2.9.0 published on Friday, Nov 7, 2025 by OVHcloud
      Meet Neo: Your AI Platform Teammate