pulumi-digitalocean-kotlin/com.pulumi.digitalocean.kotlin/DatabaseConnectionPoolArgs

DatabaseConnectionPoolArgs

data class DatabaseConnectionPoolArgs(val clusterId: Output<String>? = null, val dbName: Output<String>? = null, val mode: Output<String>? = null, val name: Output<String>? = null, val size: Output<Int>? = null, val user: Output<String>? = null) : ConvertibleToJava<DatabaseConnectionPoolArgs>

Provides a DigitalOcean database connection pool resource.

Example Usage

Create a new PostgreSQL database connection pool

import * as pulumi from "@pulumi/pulumi";
import * as digitalocean from "@pulumi/digitalocean";
const postgres_example = new digitalocean.DatabaseCluster("postgres-example", {
    name: "example-postgres-cluster",
    engine: "pg",
    version: "15",
    size: digitalocean.DatabaseSlug.DB_1VPCU1GB,
    region: digitalocean.Region.NYC1,
    nodeCount: 1,
});
const pool_01 = new digitalocean.DatabaseConnectionPool("pool-01", {
    clusterId: postgres_example.id,
    name: "pool-01",
    mode: "transaction",
    size: 20,
    dbName: "defaultdb",
    user: "doadmin",
});

import pulumi
import pulumi_digitalocean as digitalocean
postgres_example = digitalocean.DatabaseCluster("postgres-example",
    name="example-postgres-cluster",
    engine="pg",
    version="15",
    size=digitalocean.DatabaseSlug.D_B_1_VPCU1_GB,
    region=digitalocean.Region.NYC1,
    node_count=1)
pool_01 = digitalocean.DatabaseConnectionPool("pool-01",
    cluster_id=postgres_example.id,
    name="pool-01",
    mode="transaction",
    size=20,
    db_name="defaultdb",
    user="doadmin")

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using DigitalOcean = Pulumi.DigitalOcean;
return await Deployment.RunAsync(() =>
{
    var postgres_example = new DigitalOcean.DatabaseCluster("postgres-example", new()
    {
        Name = "example-postgres-cluster",
        Engine = "pg",
        Version = "15",
        Size = DigitalOcean.DatabaseSlug.DB_1VPCU1GB,
        Region = DigitalOcean.Region.NYC1,
        NodeCount = 1,
    });
    var pool_01 = new DigitalOcean.DatabaseConnectionPool("pool-01", new()
    {
        ClusterId = postgres_example.Id,
        Name = "pool-01",
        Mode = "transaction",
        Size = 20,
        DbName = "defaultdb",
        User = "doadmin",
    });
});

package main
import (
	"github.com/pulumi/pulumi-digitalocean/sdk/v4/go/digitalocean"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		postgres_example, err := digitalocean.NewDatabaseCluster(ctx, "postgres-example", &digitalocean.DatabaseClusterArgs{
			Name:      pulumi.String("example-postgres-cluster"),
			Engine:    pulumi.String("pg"),
			Version:   pulumi.String("15"),
			Size:      pulumi.String(digitalocean.DatabaseSlug_DB_1VPCU1GB),
			Region:    pulumi.String(digitalocean.RegionNYC1),
			NodeCount: pulumi.Int(1),
		})
		if err != nil {
			return err
		}
		_, err = digitalocean.NewDatabaseConnectionPool(ctx, "pool-01", &digitalocean.DatabaseConnectionPoolArgs{
			ClusterId: postgres_example.ID(),
			Name:      pulumi.String("pool-01"),
			Mode:      pulumi.String("transaction"),
			Size:      pulumi.Int(20),
			DbName:    pulumi.String("defaultdb"),
			User:      pulumi.String("doadmin"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.digitalocean.DatabaseCluster;
import com.pulumi.digitalocean.DatabaseClusterArgs;
import com.pulumi.digitalocean.DatabaseConnectionPool;
import com.pulumi.digitalocean.DatabaseConnectionPoolArgs;
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) {
        var postgres_example = new DatabaseCluster("postgres-example", DatabaseClusterArgs.builder()
            .name("example-postgres-cluster")
            .engine("pg")
            .version("15")
            .size("db-s-1vcpu-1gb")
            .region("nyc1")
            .nodeCount(1)
            .build());
        var pool_01 = new DatabaseConnectionPool("pool-01", DatabaseConnectionPoolArgs.builder()
            .clusterId(postgres_example.id())
            .name("pool-01")
            .mode("transaction")
            .size(20)
            .dbName("defaultdb")
            .user("doadmin")
            .build());
    }
}

resources:
  pool-01:
    type: digitalocean:DatabaseConnectionPool
    properties:
      clusterId: ${["postgres-example"].id}
      name: pool-01
      mode: transaction
      size: 20
      dbName: defaultdb
      user: doadmin
  postgres-example:
    type: digitalocean:DatabaseCluster
    properties:
      name: example-postgres-cluster
      engine: pg
      version: '15'
      size: db-s-1vcpu-1gb
      region: nyc1
      nodeCount: 1

Import

Database connection pools can be imported using the id of the source database cluster and the name of the connection pool joined with a comma. For example:

$ pulumi import digitalocean:index/databaseConnectionPool:DatabaseConnectionPool pool-01 245bcfd0-7f31-4ce6-a2bc-475a116cca97,pool-01

Constructors

DatabaseConnectionPoolArgs

constructor(clusterId: Output<String>? = null, dbName: Output<String>? = null, mode: Output<String>? = null, name: Output<String>? = null, size: Output<Int>? = null, user: Output<String>? = null)