1. Packages
  2. OVH
  3. API Docs
  4. CloudProjectDatabase
  5. getDatabasePostgreSQLConnectionPools
OVHCloud v2.1.0 published on Friday, Mar 28, 2025 by OVHcloud

ovh.CloudProjectDatabase.getDatabasePostgreSQLConnectionPools

Explore with Pulumi AI

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 "@pulumi/ovh";

const testPools = ovh.CloudProjectDatabase.getDatabasePostgreSQLConnectionPools({
    serviceName: "XXX",
    clusterId: "YYY",
});
export const connectionPoolIds = testPools.then(testPools => testPools.connectionPoolIds);
Copy
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)
Copy
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
	})
}
Copy
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),
    };
});
Copy
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.applyValue(getDatabasePostgreSQLConnectionPoolsResult -> getDatabasePostgreSQLConnectionPoolsResult.connectionPoolIds()));
    }
}
Copy
variables:
  testPools:
    fn::invoke:
      function: ovh:CloudProjectDatabase:getDatabasePostgreSQLConnectionPools
      arguments:
        serviceName: XXX
        clusterId: YYY
outputs:
  connectionPoolIds: ${testPools.connectionPoolIds}
Copy

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>
Copy
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]
Copy
func GetDatabasePostgreSQLConnectionPools(ctx *Context, args *GetDatabasePostgreSQLConnectionPoolsArgs, opts ...InvokeOption) (*GetDatabasePostgreSQLConnectionPoolsResult, error)
func GetDatabasePostgreSQLConnectionPoolsOutput(ctx *Context, args *GetDatabasePostgreSQLConnectionPoolsOutputArgs, opts ...InvokeOption) GetDatabasePostgreSQLConnectionPoolsResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetDatabasePostgreSQLConnectionPoolsResult> getDatabasePostgreSQLConnectionPools(GetDatabasePostgreSQLConnectionPoolsArgs args, InvokeOptions options)
public static Output<GetDatabasePostgreSQLConnectionPoolsResult> getDatabasePostgreSQLConnectionPools(GetDatabasePostgreSQLConnectionPoolsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: ovh:CloudProjectDatabase/getDatabasePostgreSQLConnectionPools:getDatabasePostgreSQLConnectionPools
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

ClusterId This property is required. string
Cluster ID.
ServiceName This property is required. string
The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
ClusterId This property is required. string
Cluster ID.
ServiceName This property is required. string
The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
clusterId This property is required. String
Cluster ID.
serviceName This property is required. String
The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
clusterId This property is required. string
Cluster ID.
serviceName This property is required. string
The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
cluster_id This property is required. str
Cluster ID.
service_name This property is required. str
The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
clusterId This property is required. String
Cluster ID.
serviceName This property is required. 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.