Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi IDP Pulumi Cloud Packages Tutorials
  1. Packages
  2. UpCloud
  3. API Docs
  4. ManagedDatabasePostgresql
UpCloud v0.4.1 published on Friday, Jul 18, 2025 by UpCloudLtd
UpCloudLtd/pulumi-upcloud

upcloud.ManagedDatabasePostgresql

Explore with Pulumi AI

upcloud logo
UpCloud v0.4.1 published on Friday, Jul 18, 2025 by UpCloudLtd
UpCloudLtd/pulumi-upcloud

    This resource represents PostgreSQL managed database. See UpCloud Managed Databases product page for more details about the service.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as upcloud from "@upcloud/pulumi-upcloud";

// Minimal config
const example1 = new upcloud.ManagedDatabasePostgresql("example_1", {
    name: "postgres-1",
    plan: "1x1xCPU-2GB-25GB",
    title: "postgres",
    zone: "fi-hel1",
});
// Service with custom properties
const example2 = new upcloud.ManagedDatabasePostgresql("example_2", {
    name: "postgres-2",
    plan: "1x1xCPU-2GB-25GB",
    title: "postgres",
    zone: "fi-hel1",
    properties: {
        timezone: "Europe/Helsinki",
        adminUsername: "admin",
        adminPassword: "<ADMIN_PASSWORD>",
    },
});

    import pulumi
import pulumi_upcloud as upcloud

# Minimal config
example1 = upcloud.ManagedDatabasePostgresql("example_1",
    name="postgres-1",
    plan="1x1xCPU-2GB-25GB",
    title="postgres",
    zone="fi-hel1")
# Service with custom properties
example2 = upcloud.ManagedDatabasePostgresql("example_2",
    name="postgres-2",
    plan="1x1xCPU-2GB-25GB",
    title="postgres",
    zone="fi-hel1",
    properties={
        "timezone": "Europe/Helsinki",
        "admin_username": "admin",
        "admin_password": "<ADMIN_PASSWORD>",
    })

    package main

import (
	"github.com/UpCloudLtd/pulumi-upcloud/sdk/go/upcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		// Minimal config
		_, err := upcloud.NewManagedDatabasePostgresql(ctx, "example_1", &upcloud.ManagedDatabasePostgresqlArgs{
			Name:  pulumi.String("postgres-1"),
			Plan:  pulumi.String("1x1xCPU-2GB-25GB"),
			Title: pulumi.String("postgres"),
			Zone:  pulumi.String("fi-hel1"),
		})
		if err != nil {
			return err
		}
		// Service with custom properties
		_, err = upcloud.NewManagedDatabasePostgresql(ctx, "example_2", &upcloud.ManagedDatabasePostgresqlArgs{
			Name:  pulumi.String("postgres-2"),
			Plan:  pulumi.String("1x1xCPU-2GB-25GB"),
			Title: pulumi.String("postgres"),
			Zone:  pulumi.String("fi-hel1"),
			Properties: &upcloud.ManagedDatabasePostgresqlPropertiesArgs{
				Timezone:      pulumi.String("Europe/Helsinki"),
				AdminUsername: pulumi.String("admin"),
				AdminPassword: pulumi.String("<ADMIN_PASSWORD>"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using UpCloud = UpCloud.Pulumi.UpCloud;

return await Deployment.RunAsync(() => 
{
    // Minimal config
    var example1 = new UpCloud.ManagedDatabasePostgresql("example_1", new()
    {
        Name = "postgres-1",
        Plan = "1x1xCPU-2GB-25GB",
        Title = "postgres",
        Zone = "fi-hel1",
    });

    // Service with custom properties
    var example2 = new UpCloud.ManagedDatabasePostgresql("example_2", new()
    {
        Name = "postgres-2",
        Plan = "1x1xCPU-2GB-25GB",
        Title = "postgres",
        Zone = "fi-hel1",
        Properties = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesArgs
        {
            Timezone = "Europe/Helsinki",
            AdminUsername = "admin",
            AdminPassword = "<ADMIN_PASSWORD>",
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.upcloud.ManagedDatabasePostgresql;
import com.pulumi.upcloud.ManagedDatabasePostgresqlArgs;
import com.pulumi.upcloud.inputs.ManagedDatabasePostgresqlPropertiesArgs;
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) {
        // Minimal config
        var example1 = new ManagedDatabasePostgresql("example1", ManagedDatabasePostgresqlArgs.builder()
            .name("postgres-1")
            .plan("1x1xCPU-2GB-25GB")
            .title("postgres")
            .zone("fi-hel1")
            .build());

        // Service with custom properties
        var example2 = new ManagedDatabasePostgresql("example2", ManagedDatabasePostgresqlArgs.builder()
            .name("postgres-2")
            .plan("1x1xCPU-2GB-25GB")
            .title("postgres")
            .zone("fi-hel1")
            .properties(ManagedDatabasePostgresqlPropertiesArgs.builder()
                .timezone("Europe/Helsinki")
                .adminUsername("admin")
                .adminPassword("<ADMIN_PASSWORD>")
                .build())
            .build());

    }
}

    resources:
  # Minimal config
  example1:
    type: upcloud:ManagedDatabasePostgresql
    name: example_1
    properties:
      name: postgres-1
      plan: 1x1xCPU-2GB-25GB
      title: postgres
      zone: fi-hel1
  # Service with custom properties
  example2:
    type: upcloud:ManagedDatabasePostgresql
    name: example_2
    properties:
      name: postgres-2
      plan: 1x1xCPU-2GB-25GB
      title: postgres
      zone: fi-hel1
      properties:
        timezone: Europe/Helsinki
        adminUsername: admin
        adminPassword: <ADMIN_PASSWORD>

    Create ManagedDatabasePostgresql Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new ManagedDatabasePostgresql(name: string, args: ManagedDatabasePostgresqlArgs, opts?: CustomResourceOptions);
    @overload
def ManagedDatabasePostgresql(resource_name: str,
                              args: ManagedDatabasePostgresqlArgs,
                              opts: Optional[ResourceOptions] = None)

@overload
def ManagedDatabasePostgresql(resource_name: str,
                              opts: Optional[ResourceOptions] = None,
                              plan: Optional[str] = None,
                              title: Optional[str] = None,
                              zone: Optional[str] = None,
                              labels: Optional[Mapping[str, str]] = None,
                              maintenance_window_dow: Optional[str] = None,
                              maintenance_window_time: Optional[str] = None,
                              name: Optional[str] = None,
                              networks: Optional[Sequence[ManagedDatabasePostgresqlNetworkArgs]] = None,
                              powered: Optional[bool] = None,
                              properties: Optional[ManagedDatabasePostgresqlPropertiesArgs] = None,
                              termination_protection: Optional[bool] = None)
    func NewManagedDatabasePostgresql(ctx *Context, name string, args ManagedDatabasePostgresqlArgs, opts ...ResourceOption) (*ManagedDatabasePostgresql, error)
    public ManagedDatabasePostgresql(string name, ManagedDatabasePostgresqlArgs args, CustomResourceOptions? opts = null)
    public ManagedDatabasePostgresql(String name, ManagedDatabasePostgresqlArgs args)
public ManagedDatabasePostgresql(String name, ManagedDatabasePostgresqlArgs args, CustomResourceOptions options)

    type: upcloud:ManagedDatabasePostgresql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var managedDatabasePostgresqlResource = new UpCloud.ManagedDatabasePostgresql("managedDatabasePostgresqlResource", new()
{
    Plan = "string",
    Title = "string",
    Zone = "string",
    Labels = 
    {
        { "string", "string" },
    },
    MaintenanceWindowDow = "string",
    MaintenanceWindowTime = "string",
    Name = "string",
    Networks = new[]
    {
        new UpCloud.Inputs.ManagedDatabasePostgresqlNetworkArgs
        {
            Family = "string",
            Name = "string",
            Type = "string",
            Uuid = "string",
        },
    },
    Powered = false,
    Properties = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesArgs
    {
        AdminPassword = "string",
        AdminUsername = "string",
        AutomaticUtilityNetworkIpFilter = false,
        AutovacuumAnalyzeScaleFactor = 0,
        AutovacuumAnalyzeThreshold = 0,
        AutovacuumFreezeMaxAge = 0,
        AutovacuumMaxWorkers = 0,
        AutovacuumNaptime = 0,
        AutovacuumVacuumCostDelay = 0,
        AutovacuumVacuumCostLimit = 0,
        AutovacuumVacuumScaleFactor = 0,
        AutovacuumVacuumThreshold = 0,
        BackupHour = 0,
        BackupMinute = 0,
        BgwriterDelay = 0,
        BgwriterFlushAfter = 0,
        BgwriterLruMaxpages = 0,
        BgwriterLruMultiplier = 0,
        DeadlockTimeout = 0,
        DefaultToastCompression = "string",
        IdleInTransactionSessionTimeout = 0,
        IpFilters = new[]
        {
            "string",
        },
        Jit = false,
        LogAutovacuumMinDuration = 0,
        LogErrorVerbosity = "string",
        LogLinePrefix = "string",
        LogMinDurationStatement = 0,
        LogTempFiles = 0,
        MaxConnections = 0,
        MaxFilesPerProcess = 0,
        MaxLocksPerTransaction = 0,
        MaxLogicalReplicationWorkers = 0,
        MaxParallelWorkers = 0,
        MaxParallelWorkersPerGather = 0,
        MaxPredLocksPerTransaction = 0,
        MaxPreparedTransactions = 0,
        MaxReplicationSlots = 0,
        MaxSlotWalKeepSize = 0,
        MaxStackDepth = 0,
        MaxStandbyArchiveDelay = 0,
        MaxStandbyStreamingDelay = 0,
        MaxSyncWorkersPerSubscription = 0,
        MaxWalSenders = 0,
        MaxWorkerProcesses = 0,
        Migration = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesMigrationArgs
        {
            Dbname = "string",
            Host = "string",
            IgnoreDbs = "string",
            IgnoreRoles = "string",
            Method = "string",
            Password = "string",
            Port = 0,
            Ssl = false,
            Username = "string",
        },
        PasswordEncryption = "string",
        PgPartmanBgwInterval = 0,
        PgPartmanBgwRole = "string",
        PgStatMonitorEnable = false,
        PgStatMonitorPgsmEnableQueryPlan = false,
        PgStatMonitorPgsmMaxBuckets = 0,
        PgStatStatementsTrack = "string",
        Pgaudit = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPgauditArgs
        {
            FeatureEnabled = false,
            LogCatalog = false,
            LogClient = false,
            LogLevel = "string",
            LogMaxStringLength = 0,
            LogNestedStatements = false,
            LogParameter = false,
            LogParameterMaxSize = 0,
            LogRelation = false,
            LogRows = false,
            LogStatement = false,
            LogStatementOnce = false,
            Logs = new[]
            {
                "string",
            },
            Role = "string",
        },
        Pgbouncer = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPgbouncerArgs
        {
            AutodbIdleTimeout = 0,
            AutodbMaxDbConnections = 0,
            AutodbPoolMode = "string",
            AutodbPoolSize = 0,
            IgnoreStartupParameters = new[]
            {
                "string",
            },
            MaxPreparedStatements = 0,
            MinPoolSize = 0,
            ServerIdleTimeout = 0,
            ServerLifetime = 0,
            ServerResetQueryAlways = false,
        },
        Pglookout = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPglookoutArgs
        {
            MaxFailoverReplicationTimeLag = 0,
        },
        PublicAccess = false,
        ServiceLog = false,
        SharedBuffersPercentage = 0,
        SynchronousReplication = "string",
        TempFileLimit = 0,
        Timescaledb = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesTimescaledbArgs
        {
            MaxBackgroundWorkers = 0,
        },
        Timezone = "string",
        TrackActivityQuerySize = 0,
        TrackCommitTimestamp = "string",
        TrackFunctions = "string",
        TrackIoTiming = "string",
        Variant = "string",
        Version = "string",
        WalSenderTimeout = 0,
        WalWriterDelay = 0,
        WorkMem = 0,
    },
    TerminationProtection = false,
});

    example, err := upcloud.NewManagedDatabasePostgresql(ctx, "managedDatabasePostgresqlResource", &upcloud.ManagedDatabasePostgresqlArgs{
	Plan:  pulumi.String("string"),
	Title: pulumi.String("string"),
	Zone:  pulumi.String("string"),
	Labels: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	MaintenanceWindowDow:  pulumi.String("string"),
	MaintenanceWindowTime: pulumi.String("string"),
	Name:                  pulumi.String("string"),
	Networks: upcloud.ManagedDatabasePostgresqlNetworkArray{
		&upcloud.ManagedDatabasePostgresqlNetworkArgs{
			Family: pulumi.String("string"),
			Name:   pulumi.String("string"),
			Type:   pulumi.String("string"),
			Uuid:   pulumi.String("string"),
		},
	},
	Powered: pulumi.Bool(false),
	Properties: &upcloud.ManagedDatabasePostgresqlPropertiesArgs{
		AdminPassword:                   pulumi.String("string"),
		AdminUsername:                   pulumi.String("string"),
		AutomaticUtilityNetworkIpFilter: pulumi.Bool(false),
		AutovacuumAnalyzeScaleFactor:    pulumi.Float64(0),
		AutovacuumAnalyzeThreshold:      pulumi.Int(0),
		AutovacuumFreezeMaxAge:          pulumi.Int(0),
		AutovacuumMaxWorkers:            pulumi.Int(0),
		AutovacuumNaptime:               pulumi.Int(0),
		AutovacuumVacuumCostDelay:       pulumi.Int(0),
		AutovacuumVacuumCostLimit:       pulumi.Int(0),
		AutovacuumVacuumScaleFactor:     pulumi.Float64(0),
		AutovacuumVacuumThreshold:       pulumi.Int(0),
		BackupHour:                      pulumi.Int(0),
		BackupMinute:                    pulumi.Int(0),
		BgwriterDelay:                   pulumi.Int(0),
		BgwriterFlushAfter:              pulumi.Int(0),
		BgwriterLruMaxpages:             pulumi.Int(0),
		BgwriterLruMultiplier:           pulumi.Float64(0),
		DeadlockTimeout:                 pulumi.Int(0),
		DefaultToastCompression:         pulumi.String("string"),
		IdleInTransactionSessionTimeout: pulumi.Int(0),
		IpFilters: pulumi.StringArray{
			pulumi.String("string"),
		},
		Jit:                           pulumi.Bool(false),
		LogAutovacuumMinDuration:      pulumi.Int(0),
		LogErrorVerbosity:             pulumi.String("string"),
		LogLinePrefix:                 pulumi.String("string"),
		LogMinDurationStatement:       pulumi.Int(0),
		LogTempFiles:                  pulumi.Int(0),
		MaxConnections:                pulumi.Int(0),
		MaxFilesPerProcess:            pulumi.Int(0),
		MaxLocksPerTransaction:        pulumi.Int(0),
		MaxLogicalReplicationWorkers:  pulumi.Int(0),
		MaxParallelWorkers:            pulumi.Int(0),
		MaxParallelWorkersPerGather:   pulumi.Int(0),
		MaxPredLocksPerTransaction:    pulumi.Int(0),
		MaxPreparedTransactions:       pulumi.Int(0),
		MaxReplicationSlots:           pulumi.Int(0),
		MaxSlotWalKeepSize:            pulumi.Int(0),
		MaxStackDepth:                 pulumi.Int(0),
		MaxStandbyArchiveDelay:        pulumi.Int(0),
		MaxStandbyStreamingDelay:      pulumi.Int(0),
		MaxSyncWorkersPerSubscription: pulumi.Int(0),
		MaxWalSenders:                 pulumi.Int(0),
		MaxWorkerProcesses:            pulumi.Int(0),
		Migration: &upcloud.ManagedDatabasePostgresqlPropertiesMigrationArgs{
			Dbname:      pulumi.String("string"),
			Host:        pulumi.String("string"),
			IgnoreDbs:   pulumi.String("string"),
			IgnoreRoles: pulumi.String("string"),
			Method:      pulumi.String("string"),
			Password:    pulumi.String("string"),
			Port:        pulumi.Int(0),
			Ssl:         pulumi.Bool(false),
			Username:    pulumi.String("string"),
		},
		PasswordEncryption:               pulumi.String("string"),
		PgPartmanBgwInterval:             pulumi.Int(0),
		PgPartmanBgwRole:                 pulumi.String("string"),
		PgStatMonitorEnable:              pulumi.Bool(false),
		PgStatMonitorPgsmEnableQueryPlan: pulumi.Bool(false),
		PgStatMonitorPgsmMaxBuckets:      pulumi.Int(0),
		PgStatStatementsTrack:            pulumi.String("string"),
		Pgaudit: &upcloud.ManagedDatabasePostgresqlPropertiesPgauditArgs{
			FeatureEnabled:      pulumi.Bool(false),
			LogCatalog:          pulumi.Bool(false),
			LogClient:           pulumi.Bool(false),
			LogLevel:            pulumi.String("string"),
			LogMaxStringLength:  pulumi.Int(0),
			LogNestedStatements: pulumi.Bool(false),
			LogParameter:        pulumi.Bool(false),
			LogParameterMaxSize: pulumi.Int(0),
			LogRelation:         pulumi.Bool(false),
			LogRows:             pulumi.Bool(false),
			LogStatement:        pulumi.Bool(false),
			LogStatementOnce:    pulumi.Bool(false),
			Logs: pulumi.StringArray{
				pulumi.String("string"),
			},
			Role: pulumi.String("string"),
		},
		Pgbouncer: &upcloud.ManagedDatabasePostgresqlPropertiesPgbouncerArgs{
			AutodbIdleTimeout:      pulumi.Int(0),
			AutodbMaxDbConnections: pulumi.Int(0),
			AutodbPoolMode:         pulumi.String("string"),
			AutodbPoolSize:         pulumi.Int(0),
			IgnoreStartupParameters: pulumi.StringArray{
				pulumi.String("string"),
			},
			MaxPreparedStatements:  pulumi.Int(0),
			MinPoolSize:            pulumi.Int(0),
			ServerIdleTimeout:      pulumi.Int(0),
			ServerLifetime:         pulumi.Int(0),
			ServerResetQueryAlways: pulumi.Bool(false),
		},
		Pglookout: &upcloud.ManagedDatabasePostgresqlPropertiesPglookoutArgs{
			MaxFailoverReplicationTimeLag: pulumi.Int(0),
		},
		PublicAccess:            pulumi.Bool(false),
		ServiceLog:              pulumi.Bool(false),
		SharedBuffersPercentage: pulumi.Float64(0),
		SynchronousReplication:  pulumi.String("string"),
		TempFileLimit:           pulumi.Int(0),
		Timescaledb: &upcloud.ManagedDatabasePostgresqlPropertiesTimescaledbArgs{
			MaxBackgroundWorkers: pulumi.Int(0),
		},
		Timezone:               pulumi.String("string"),
		TrackActivityQuerySize: pulumi.Int(0),
		TrackCommitTimestamp:   pulumi.String("string"),
		TrackFunctions:         pulumi.String("string"),
		TrackIoTiming:          pulumi.String("string"),
		Variant:                pulumi.String("string"),
		Version:                pulumi.String("string"),
		WalSenderTimeout:       pulumi.Int(0),
		WalWriterDelay:         pulumi.Int(0),
		WorkMem:                pulumi.Int(0),
	},
	TerminationProtection: pulumi.Bool(false),
})

    var managedDatabasePostgresqlResource = new ManagedDatabasePostgresql("managedDatabasePostgresqlResource", ManagedDatabasePostgresqlArgs.builder()
    .plan("string")
    .title("string")
    .zone("string")
    .labels(Map.of("string", "string"))
    .maintenanceWindowDow("string")
    .maintenanceWindowTime("string")
    .name("string")
    .networks(ManagedDatabasePostgresqlNetworkArgs.builder()
        .family("string")
        .name("string")
        .type("string")
        .uuid("string")
        .build())
    .powered(false)
    .properties(ManagedDatabasePostgresqlPropertiesArgs.builder()
        .adminPassword("string")
        .adminUsername("string")
        .automaticUtilityNetworkIpFilter(false)
        .autovacuumAnalyzeScaleFactor(0.0)
        .autovacuumAnalyzeThreshold(0)
        .autovacuumFreezeMaxAge(0)
        .autovacuumMaxWorkers(0)
        .autovacuumNaptime(0)
        .autovacuumVacuumCostDelay(0)
        .autovacuumVacuumCostLimit(0)
        .autovacuumVacuumScaleFactor(0.0)
        .autovacuumVacuumThreshold(0)
        .backupHour(0)
        .backupMinute(0)
        .bgwriterDelay(0)
        .bgwriterFlushAfter(0)
        .bgwriterLruMaxpages(0)
        .bgwriterLruMultiplier(0.0)
        .deadlockTimeout(0)
        .defaultToastCompression("string")
        .idleInTransactionSessionTimeout(0)
        .ipFilters("string")
        .jit(false)
        .logAutovacuumMinDuration(0)
        .logErrorVerbosity("string")
        .logLinePrefix("string")
        .logMinDurationStatement(0)
        .logTempFiles(0)
        .maxConnections(0)
        .maxFilesPerProcess(0)
        .maxLocksPerTransaction(0)
        .maxLogicalReplicationWorkers(0)
        .maxParallelWorkers(0)
        .maxParallelWorkersPerGather(0)
        .maxPredLocksPerTransaction(0)
        .maxPreparedTransactions(0)
        .maxReplicationSlots(0)
        .maxSlotWalKeepSize(0)
        .maxStackDepth(0)
        .maxStandbyArchiveDelay(0)
        .maxStandbyStreamingDelay(0)
        .maxSyncWorkersPerSubscription(0)
        .maxWalSenders(0)
        .maxWorkerProcesses(0)
        .migration(ManagedDatabasePostgresqlPropertiesMigrationArgs.builder()
            .dbname("string")
            .host("string")
            .ignoreDbs("string")
            .ignoreRoles("string")
            .method("string")
            .password("string")
            .port(0)
            .ssl(false)
            .username("string")
            .build())
        .passwordEncryption("string")
        .pgPartmanBgwInterval(0)
        .pgPartmanBgwRole("string")
        .pgStatMonitorEnable(false)
        .pgStatMonitorPgsmEnableQueryPlan(false)
        .pgStatMonitorPgsmMaxBuckets(0)
        .pgStatStatementsTrack("string")
        .pgaudit(ManagedDatabasePostgresqlPropertiesPgauditArgs.builder()
            .featureEnabled(false)
            .logCatalog(false)
            .logClient(false)
            .logLevel("string")
            .logMaxStringLength(0)
            .logNestedStatements(false)
            .logParameter(false)
            .logParameterMaxSize(0)
            .logRelation(false)
            .logRows(false)
            .logStatement(false)
            .logStatementOnce(false)
            .logs("string")
            .role("string")
            .build())
        .pgbouncer(ManagedDatabasePostgresqlPropertiesPgbouncerArgs.builder()
            .autodbIdleTimeout(0)
            .autodbMaxDbConnections(0)
            .autodbPoolMode("string")
            .autodbPoolSize(0)
            .ignoreStartupParameters("string")
            .maxPreparedStatements(0)
            .minPoolSize(0)
            .serverIdleTimeout(0)
            .serverLifetime(0)
            .serverResetQueryAlways(false)
            .build())
        .pglookout(ManagedDatabasePostgresqlPropertiesPglookoutArgs.builder()
            .maxFailoverReplicationTimeLag(0)
            .build())
        .publicAccess(false)
        .serviceLog(false)
        .sharedBuffersPercentage(0.0)
        .synchronousReplication("string")
        .tempFileLimit(0)
        .timescaledb(ManagedDatabasePostgresqlPropertiesTimescaledbArgs.builder()
            .maxBackgroundWorkers(0)
            .build())
        .timezone("string")
        .trackActivityQuerySize(0)
        .trackCommitTimestamp("string")
        .trackFunctions("string")
        .trackIoTiming("string")
        .variant("string")
        .version("string")
        .walSenderTimeout(0)
        .walWriterDelay(0)
        .workMem(0)
        .build())
    .terminationProtection(false)
    .build());

    managed_database_postgresql_resource = upcloud.ManagedDatabasePostgresql("managedDatabasePostgresqlResource",
    plan="string",
    title="string",
    zone="string",
    labels={
        "string": "string",
    },
    maintenance_window_dow="string",
    maintenance_window_time="string",
    name="string",
    networks=[{
        "family": "string",
        "name": "string",
        "type": "string",
        "uuid": "string",
    }],
    powered=False,
    properties={
        "admin_password": "string",
        "admin_username": "string",
        "automatic_utility_network_ip_filter": False,
        "autovacuum_analyze_scale_factor": 0,
        "autovacuum_analyze_threshold": 0,
        "autovacuum_freeze_max_age": 0,
        "autovacuum_max_workers": 0,
        "autovacuum_naptime": 0,
        "autovacuum_vacuum_cost_delay": 0,
        "autovacuum_vacuum_cost_limit": 0,
        "autovacuum_vacuum_scale_factor": 0,
        "autovacuum_vacuum_threshold": 0,
        "backup_hour": 0,
        "backup_minute": 0,
        "bgwriter_delay": 0,
        "bgwriter_flush_after": 0,
        "bgwriter_lru_maxpages": 0,
        "bgwriter_lru_multiplier": 0,
        "deadlock_timeout": 0,
        "default_toast_compression": "string",
        "idle_in_transaction_session_timeout": 0,
        "ip_filters": ["string"],
        "jit": False,
        "log_autovacuum_min_duration": 0,
        "log_error_verbosity": "string",
        "log_line_prefix": "string",
        "log_min_duration_statement": 0,
        "log_temp_files": 0,
        "max_connections": 0,
        "max_files_per_process": 0,
        "max_locks_per_transaction": 0,
        "max_logical_replication_workers": 0,
        "max_parallel_workers": 0,
        "max_parallel_workers_per_gather": 0,
        "max_pred_locks_per_transaction": 0,
        "max_prepared_transactions": 0,
        "max_replication_slots": 0,
        "max_slot_wal_keep_size": 0,
        "max_stack_depth": 0,
        "max_standby_archive_delay": 0,
        "max_standby_streaming_delay": 0,
        "max_sync_workers_per_subscription": 0,
        "max_wal_senders": 0,
        "max_worker_processes": 0,
        "migration": {
            "dbname": "string",
            "host": "string",
            "ignore_dbs": "string",
            "ignore_roles": "string",
            "method": "string",
            "password": "string",
            "port": 0,
            "ssl": False,
            "username": "string",
        },
        "password_encryption": "string",
        "pg_partman_bgw_interval": 0,
        "pg_partman_bgw_role": "string",
        "pg_stat_monitor_enable": False,
        "pg_stat_monitor_pgsm_enable_query_plan": False,
        "pg_stat_monitor_pgsm_max_buckets": 0,
        "pg_stat_statements_track": "string",
        "pgaudit": {
            "feature_enabled": False,
            "log_catalog": False,
            "log_client": False,
            "log_level": "string",
            "log_max_string_length": 0,
            "log_nested_statements": False,
            "log_parameter": False,
            "log_parameter_max_size": 0,
            "log_relation": False,
            "log_rows": False,
            "log_statement": False,
            "log_statement_once": False,
            "logs": ["string"],
            "role": "string",
        },
        "pgbouncer": {
            "autodb_idle_timeout": 0,
            "autodb_max_db_connections": 0,
            "autodb_pool_mode": "string",
            "autodb_pool_size": 0,
            "ignore_startup_parameters": ["string"],
            "max_prepared_statements": 0,
            "min_pool_size": 0,
            "server_idle_timeout": 0,
            "server_lifetime": 0,
            "server_reset_query_always": False,
        },
        "pglookout": {
            "max_failover_replication_time_lag": 0,
        },
        "public_access": False,
        "service_log": False,
        "shared_buffers_percentage": 0,
        "synchronous_replication": "string",
        "temp_file_limit": 0,
        "timescaledb": {
            "max_background_workers": 0,
        },
        "timezone": "string",
        "track_activity_query_size": 0,
        "track_commit_timestamp": "string",
        "track_functions": "string",
        "track_io_timing": "string",
        "variant": "string",
        "version": "string",
        "wal_sender_timeout": 0,
        "wal_writer_delay": 0,
        "work_mem": 0,
    },
    termination_protection=False)

    const managedDatabasePostgresqlResource = new upcloud.ManagedDatabasePostgresql("managedDatabasePostgresqlResource", {
    plan: "string",
    title: "string",
    zone: "string",
    labels: {
        string: "string",
    },
    maintenanceWindowDow: "string",
    maintenanceWindowTime: "string",
    name: "string",
    networks: [{
        family: "string",
        name: "string",
        type: "string",
        uuid: "string",
    }],
    powered: false,
    properties: {
        adminPassword: "string",
        adminUsername: "string",
        automaticUtilityNetworkIpFilter: false,
        autovacuumAnalyzeScaleFactor: 0,
        autovacuumAnalyzeThreshold: 0,
        autovacuumFreezeMaxAge: 0,
        autovacuumMaxWorkers: 0,
        autovacuumNaptime: 0,
        autovacuumVacuumCostDelay: 0,
        autovacuumVacuumCostLimit: 0,
        autovacuumVacuumScaleFactor: 0,
        autovacuumVacuumThreshold: 0,
        backupHour: 0,
        backupMinute: 0,
        bgwriterDelay: 0,
        bgwriterFlushAfter: 0,
        bgwriterLruMaxpages: 0,
        bgwriterLruMultiplier: 0,
        deadlockTimeout: 0,
        defaultToastCompression: "string",
        idleInTransactionSessionTimeout: 0,
        ipFilters: ["string"],
        jit: false,
        logAutovacuumMinDuration: 0,
        logErrorVerbosity: "string",
        logLinePrefix: "string",
        logMinDurationStatement: 0,
        logTempFiles: 0,
        maxConnections: 0,
        maxFilesPerProcess: 0,
        maxLocksPerTransaction: 0,
        maxLogicalReplicationWorkers: 0,
        maxParallelWorkers: 0,
        maxParallelWorkersPerGather: 0,
        maxPredLocksPerTransaction: 0,
        maxPreparedTransactions: 0,
        maxReplicationSlots: 0,
        maxSlotWalKeepSize: 0,
        maxStackDepth: 0,
        maxStandbyArchiveDelay: 0,
        maxStandbyStreamingDelay: 0,
        maxSyncWorkersPerSubscription: 0,
        maxWalSenders: 0,
        maxWorkerProcesses: 0,
        migration: {
            dbname: "string",
            host: "string",
            ignoreDbs: "string",
            ignoreRoles: "string",
            method: "string",
            password: "string",
            port: 0,
            ssl: false,
            username: "string",
        },
        passwordEncryption: "string",
        pgPartmanBgwInterval: 0,
        pgPartmanBgwRole: "string",
        pgStatMonitorEnable: false,
        pgStatMonitorPgsmEnableQueryPlan: false,
        pgStatMonitorPgsmMaxBuckets: 0,
        pgStatStatementsTrack: "string",
        pgaudit: {
            featureEnabled: false,
            logCatalog: false,
            logClient: false,
            logLevel: "string",
            logMaxStringLength: 0,
            logNestedStatements: false,
            logParameter: false,
            logParameterMaxSize: 0,
            logRelation: false,
            logRows: false,
            logStatement: false,
            logStatementOnce: false,
            logs: ["string"],
            role: "string",
        },
        pgbouncer: {
            autodbIdleTimeout: 0,
            autodbMaxDbConnections: 0,
            autodbPoolMode: "string",
            autodbPoolSize: 0,
            ignoreStartupParameters: ["string"],
            maxPreparedStatements: 0,
            minPoolSize: 0,
            serverIdleTimeout: 0,
            serverLifetime: 0,
            serverResetQueryAlways: false,
        },
        pglookout: {
            maxFailoverReplicationTimeLag: 0,
        },
        publicAccess: false,
        serviceLog: false,
        sharedBuffersPercentage: 0,
        synchronousReplication: "string",
        tempFileLimit: 0,
        timescaledb: {
            maxBackgroundWorkers: 0,
        },
        timezone: "string",
        trackActivityQuerySize: 0,
        trackCommitTimestamp: "string",
        trackFunctions: "string",
        trackIoTiming: "string",
        variant: "string",
        version: "string",
        walSenderTimeout: 0,
        walWriterDelay: 0,
        workMem: 0,
    },
    terminationProtection: false,
});

    type: upcloud:ManagedDatabasePostgresql
properties:
    labels:
        string: string
    maintenanceWindowDow: string
    maintenanceWindowTime: string
    name: string
    networks:
        - family: string
          name: string
          type: string
          uuid: string
    plan: string
    powered: false
    properties:
        adminPassword: string
        adminUsername: string
        automaticUtilityNetworkIpFilter: false
        autovacuumAnalyzeScaleFactor: 0
        autovacuumAnalyzeThreshold: 0
        autovacuumFreezeMaxAge: 0
        autovacuumMaxWorkers: 0
        autovacuumNaptime: 0
        autovacuumVacuumCostDelay: 0
        autovacuumVacuumCostLimit: 0
        autovacuumVacuumScaleFactor: 0
        autovacuumVacuumThreshold: 0
        backupHour: 0
        backupMinute: 0
        bgwriterDelay: 0
        bgwriterFlushAfter: 0
        bgwriterLruMaxpages: 0
        bgwriterLruMultiplier: 0
        deadlockTimeout: 0
        defaultToastCompression: string
        idleInTransactionSessionTimeout: 0
        ipFilters:
            - string
        jit: false
        logAutovacuumMinDuration: 0
        logErrorVerbosity: string
        logLinePrefix: string
        logMinDurationStatement: 0
        logTempFiles: 0
        maxConnections: 0
        maxFilesPerProcess: 0
        maxLocksPerTransaction: 0
        maxLogicalReplicationWorkers: 0
        maxParallelWorkers: 0
        maxParallelWorkersPerGather: 0
        maxPredLocksPerTransaction: 0
        maxPreparedTransactions: 0
        maxReplicationSlots: 0
        maxSlotWalKeepSize: 0
        maxStackDepth: 0
        maxStandbyArchiveDelay: 0
        maxStandbyStreamingDelay: 0
        maxSyncWorkersPerSubscription: 0
        maxWalSenders: 0
        maxWorkerProcesses: 0
        migration:
            dbname: string
            host: string
            ignoreDbs: string
            ignoreRoles: string
            method: string
            password: string
            port: 0
            ssl: false
            username: string
        passwordEncryption: string
        pgPartmanBgwInterval: 0
        pgPartmanBgwRole: string
        pgStatMonitorEnable: false
        pgStatMonitorPgsmEnableQueryPlan: false
        pgStatMonitorPgsmMaxBuckets: 0
        pgStatStatementsTrack: string
        pgaudit:
            featureEnabled: false
            logCatalog: false
            logClient: false
            logLevel: string
            logMaxStringLength: 0
            logNestedStatements: false
            logParameter: false
            logParameterMaxSize: 0
            logRelation: false
            logRows: false
            logStatement: false
            logStatementOnce: false
            logs:
                - string
            role: string
        pgbouncer:
            autodbIdleTimeout: 0
            autodbMaxDbConnections: 0
            autodbPoolMode: string
            autodbPoolSize: 0
            ignoreStartupParameters:
                - string
            maxPreparedStatements: 0
            minPoolSize: 0
            serverIdleTimeout: 0
            serverLifetime: 0
            serverResetQueryAlways: false
        pglookout:
            maxFailoverReplicationTimeLag: 0
        publicAccess: false
        serviceLog: false
        sharedBuffersPercentage: 0
        synchronousReplication: string
        tempFileLimit: 0
        timescaledb:
            maxBackgroundWorkers: 0
        timezone: string
        trackActivityQuerySize: 0
        trackCommitTimestamp: string
        trackFunctions: string
        trackIoTiming: string
        variant: string
        version: string
        walSenderTimeout: 0
        walWriterDelay: 0
        workMem: 0
    terminationProtection: false
    title: string
    zone: string

    ManagedDatabasePostgresql Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The ManagedDatabasePostgresql resource accepts the following input properties:

    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Title string
    Title of a managed database instance
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Labels Dictionary<string, string>
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    Powered bool
    The administrative power state of the service
    Properties UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Title string
    Title of a managed database instance
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Labels map[string]string
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks []ManagedDatabasePostgresqlNetworkArgs
    Private networks attached to the managed database
    Powered bool
    The administrative power state of the service
    Properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title String
    Title of a managed database instance
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Map<String,String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    powered Boolean
    The administrative power state of the service
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title string
    Title of a managed database instance
    zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels {[key: string]: string}
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks ManagedDatabasePostgresqlNetwork[]
    Private networks attached to the managed database
    powered boolean
    The administrative power state of the service
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    terminationProtection boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    plan str
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title str
    Title of a managed database instance
    zone str
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Mapping[str, str]
    User defined key-value pairs to classify the managed database.
    maintenance_window_dow str
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenance_window_time str
    Maintenance window UTC time in hh:mm:ss format
    name str
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks Sequence[ManagedDatabasePostgresqlNetworkArgs]
    Private networks attached to the managed database
    powered bool
    The administrative power state of the service
    properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    termination_protection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title String
    Title of a managed database instance
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Map<String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<Property Map>
    Private networks attached to the managed database
    powered Boolean
    The administrative power state of the service
    properties Property Map
    Database Engine properties for PostgreSQL
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the ManagedDatabasePostgresql resource produces the following output properties:

    Components List<UpCloud.Pulumi.UpCloud.Outputs.ManagedDatabasePostgresqlComponent>
    Service component information
    Id string
    The provider-assigned unique ID for this managed resource.
    NodeStates List<UpCloud.Pulumi.UpCloud.Outputs.ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    PrimaryDatabase string
    Primary database name
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    Type string
    Type of the service
    Components []ManagedDatabasePostgresqlComponent
    Service component information
    Id string
    The provider-assigned unique ID for this managed resource.
    NodeStates []ManagedDatabasePostgresqlNodeState
    Information about nodes providing the managed service
    PrimaryDatabase string
    Primary database name
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    Type string
    Type of the service
    components List<ManagedDatabasePostgresqlComponent>
    Service component information
    id String
    The provider-assigned unique ID for this managed resource.
    nodeStates List<ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    primaryDatabase String
    Primary database name
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    type String
    Type of the service
    components ManagedDatabasePostgresqlComponent[]
    Service component information
    id string
    The provider-assigned unique ID for this managed resource.
    nodeStates ManagedDatabasePostgresqlNodeState[]
    Information about nodes providing the managed service
    primaryDatabase string
    Primary database name
    serviceHost string
    Hostname to the service instance
    servicePassword string
    Primary username's password to the service instance
    servicePort string
    Port to the service instance
    serviceUri string
    URI to the service instance
    serviceUsername string
    Primary username to the service instance
    sslmode string
    SSL Connection Mode for PostgreSQL
    state string
    State of the service
    type string
    Type of the service
    components Sequence[ManagedDatabasePostgresqlComponent]
    Service component information
    id str
    The provider-assigned unique ID for this managed resource.
    node_states Sequence[ManagedDatabasePostgresqlNodeState]
    Information about nodes providing the managed service
    primary_database str
    Primary database name
    service_host str
    Hostname to the service instance
    service_password str
    Primary username's password to the service instance
    service_port str
    Port to the service instance
    service_uri str
    URI to the service instance
    service_username str
    Primary username to the service instance
    sslmode str
    SSL Connection Mode for PostgreSQL
    state str
    State of the service
    type str
    Type of the service
    components List<Property Map>
    Service component information
    id String
    The provider-assigned unique ID for this managed resource.
    nodeStates List<Property Map>
    Information about nodes providing the managed service
    primaryDatabase String
    Primary database name
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    type String
    Type of the service

    Look up Existing ManagedDatabasePostgresql Resource

    Get an existing ManagedDatabasePostgresql resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: ManagedDatabasePostgresqlState, opts?: CustomResourceOptions): ManagedDatabasePostgresql
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        components: Optional[Sequence[ManagedDatabasePostgresqlComponentArgs]] = None,
        labels: Optional[Mapping[str, str]] = None,
        maintenance_window_dow: Optional[str] = None,
        maintenance_window_time: Optional[str] = None,
        name: Optional[str] = None,
        networks: Optional[Sequence[ManagedDatabasePostgresqlNetworkArgs]] = None,
        node_states: Optional[Sequence[ManagedDatabasePostgresqlNodeStateArgs]] = None,
        plan: Optional[str] = None,
        powered: Optional[bool] = None,
        primary_database: Optional[str] = None,
        properties: Optional[ManagedDatabasePostgresqlPropertiesArgs] = None,
        service_host: Optional[str] = None,
        service_password: Optional[str] = None,
        service_port: Optional[str] = None,
        service_uri: Optional[str] = None,
        service_username: Optional[str] = None,
        sslmode: Optional[str] = None,
        state: Optional[str] = None,
        termination_protection: Optional[bool] = None,
        title: Optional[str] = None,
        type: Optional[str] = None,
        zone: Optional[str] = None) -> ManagedDatabasePostgresql
    func GetManagedDatabasePostgresql(ctx *Context, name string, id IDInput, state *ManagedDatabasePostgresqlState, opts ...ResourceOption) (*ManagedDatabasePostgresql, error)
    public static ManagedDatabasePostgresql Get(string name, Input<string> id, ManagedDatabasePostgresqlState? state, CustomResourceOptions? opts = null)
    public static ManagedDatabasePostgresql get(String name, Output<String> id, ManagedDatabasePostgresqlState state, CustomResourceOptions options)
    resources:  _:    type: upcloud:ManagedDatabasePostgresql    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Components List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlComponent>
    Service component information
    Labels Dictionary<string, string>
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    NodeStates List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Powered bool
    The administrative power state of the service
    PrimaryDatabase string
    Primary database name
    Properties UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Title string
    Title of a managed database instance
    Type string
    Type of the service
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Components []ManagedDatabasePostgresqlComponentArgs
    Service component information
    Labels map[string]string
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks []ManagedDatabasePostgresqlNetworkArgs
    Private networks attached to the managed database
    NodeStates []ManagedDatabasePostgresqlNodeStateArgs
    Information about nodes providing the managed service
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Powered bool
    The administrative power state of the service
    PrimaryDatabase string
    Primary database name
    Properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Title string
    Title of a managed database instance
    Type string
    Type of the service
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components List<ManagedDatabasePostgresqlComponent>
    Service component information
    labels Map<String,String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    nodeStates List<ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered Boolean
    The administrative power state of the service
    primaryDatabase String
    Primary database name
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title String
    Title of a managed database instance
    type String
    Type of the service
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components ManagedDatabasePostgresqlComponent[]
    Service component information
    labels {[key: string]: string}
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks ManagedDatabasePostgresqlNetwork[]
    Private networks attached to the managed database
    nodeStates ManagedDatabasePostgresqlNodeState[]
    Information about nodes providing the managed service
    plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered boolean
    The administrative power state of the service
    primaryDatabase string
    Primary database name
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    serviceHost string
    Hostname to the service instance
    servicePassword string
    Primary username's password to the service instance
    servicePort string
    Port to the service instance
    serviceUri string
    URI to the service instance
    serviceUsername string
    Primary username to the service instance
    sslmode string
    SSL Connection Mode for PostgreSQL
    state string
    State of the service
    terminationProtection boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title string
    Title of a managed database instance
    type string
    Type of the service
    zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components Sequence[ManagedDatabasePostgresqlComponentArgs]
    Service component information
    labels Mapping[str, str]
    User defined key-value pairs to classify the managed database.
    maintenance_window_dow str
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenance_window_time str
    Maintenance window UTC time in hh:mm:ss format
    name str
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks Sequence[ManagedDatabasePostgresqlNetworkArgs]
    Private networks attached to the managed database
    node_states Sequence[ManagedDatabasePostgresqlNodeStateArgs]
    Information about nodes providing the managed service
    plan str
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered bool
    The administrative power state of the service
    primary_database str
    Primary database name
    properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    service_host str
    Hostname to the service instance
    service_password str
    Primary username's password to the service instance
    service_port str
    Port to the service instance
    service_uri str
    URI to the service instance
    service_username str
    Primary username to the service instance
    sslmode str
    SSL Connection Mode for PostgreSQL
    state str
    State of the service
    termination_protection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    title str
    Title of a managed database instance
    type str
    Type of the service
    zone str
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components List<Property Map>
    Service component information
    labels Map<String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<Property Map>
    Private networks attached to the managed database
    nodeStates List<Property Map>
    Information about nodes providing the managed service
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered Boolean
    The administrative power state of the service
    primaryDatabase String
    Primary database name
    properties Property Map
    Database Engine properties for PostgreSQL
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title String
    Title of a managed database instance
    type String
    Type of the service
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.

    Supporting Types

    ManagedDatabasePostgresqlComponent, ManagedDatabasePostgresqlComponentArgs

    Component string
    Type of the component
    Host string
    Hostname of the component
    Port int
    Port number of the component
    Route string
    Component network route type
    Usage string
    Usage of the component
    Component string
    Type of the component
    Host string
    Hostname of the component
    Port int
    Port number of the component
    Route string
    Component network route type
    Usage string
    Usage of the component
    component String
    Type of the component
    host String
    Hostname of the component
    port Integer
    Port number of the component
    route String
    Component network route type
    usage String
    Usage of the component
    component string
    Type of the component
    host string
    Hostname of the component
    port number
    Port number of the component
    route string
    Component network route type
    usage string
    Usage of the component
    component str
    Type of the component
    host str
    Hostname of the component
    port int
    Port number of the component
    route str
    Component network route type
    usage str
    Usage of the component
    component String
    Type of the component
    host String
    Hostname of the component
    port Number
    Port number of the component
    route String
    Component network route type
    usage String
    Usage of the component

    ManagedDatabasePostgresqlNetwork, ManagedDatabasePostgresqlNetworkArgs

    Family string
    Network family. Currently only IPv4 is supported.
    Name string
    The name of the network. Must be unique within the service.
    Type string
    The type of the network. Must be private.
    Uuid string
    Private network UUID. Must reside in the same zone as the database.
    Family string
    Network family. Currently only IPv4 is supported.
    Name string
    The name of the network. Must be unique within the service.
    Type string
    The type of the network. Must be private.
    Uuid string
    Private network UUID. Must reside in the same zone as the database.
    family String
    Network family. Currently only IPv4 is supported.
    name String
    The name of the network. Must be unique within the service.
    type String
    The type of the network. Must be private.
    uuid String
    Private network UUID. Must reside in the same zone as the database.
    family string
    Network family. Currently only IPv4 is supported.
    name string
    The name of the network. Must be unique within the service.
    type string
    The type of the network. Must be private.
    uuid string
    Private network UUID. Must reside in the same zone as the database.
    family str
    Network family. Currently only IPv4 is supported.
    name str
    The name of the network. Must be unique within the service.
    type str
    The type of the network. Must be private.
    uuid str
    Private network UUID. Must reside in the same zone as the database.
    family String
    Network family. Currently only IPv4 is supported.
    name String
    The name of the network. Must be unique within the service.
    type String
    The type of the network. Must be private.
    uuid String
    Private network UUID. Must reside in the same zone as the database.

    ManagedDatabasePostgresqlNodeState, ManagedDatabasePostgresqlNodeStateArgs

    Name string
    Name plus a node iteration
    Role string
    Role of the node
    State string
    State of the node
    Name string
    Name plus a node iteration
    Role string
    Role of the node
    State string
    State of the node
    name String
    Name plus a node iteration
    role String
    Role of the node
    state String
    State of the node
    name string
    Name plus a node iteration
    role string
    Role of the node
    state string
    State of the node
    name str
    Name plus a node iteration
    role str
    Role of the node
    state str
    State of the node
    name String
    Name plus a node iteration
    role String
    Role of the node
    state String
    State of the node

    ManagedDatabasePostgresqlProperties, ManagedDatabasePostgresqlPropertiesArgs

    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    AutomaticUtilityNetworkIpFilter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    AutovacuumAnalyzeScaleFactor double
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE (e.g. 0.2 for 20% of the table size). The default is 0.2.
    AutovacuumAnalyzeThreshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50.
    AutovacuumFreezeMaxAge int
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. The system launches autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. Changing this parameter causes a service restart.
    AutovacuumMaxWorkers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. Changing this parameter causes a service restart.
    AutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds. The default is 60.
    AutovacuumVacuumCostDelay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default is 2 (upstream default).
    AutovacuumVacuumCostLimit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_limit value will be used. The default is -1 (upstream default).
    AutovacuumVacuumScaleFactor double
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM (e.g. 0.2 for 20% of the table size). The default is 0.2.
    AutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50.
    BackupHour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    BackupMinute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    BgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. The default is 200.
    BgwriterFlushAfter int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes. Setting of 0 disables forced writeback. The default is 512.
    BgwriterLruMaxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. The default is 100.
    BgwriterLruMultiplier double
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    DeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
    DefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
    IdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    IpFilters List<string>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    Jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    LogAutovacuumMinDuration int
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one disables logging autovacuum actions. The default is 1000.
    LogErrorVerbosity string
    Controls the amount of detail written in the server log for each message that is logged.
    LogLinePrefix string
    Choose from one of the available log formats.
    LogMinDurationStatement int
    Log statements that take more than this number of milliseconds to run, -1 disables.
    LogTempFiles int
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    MaxConnections int
    PostgreSQL maximum number of concurrent connections to the database server. Changing this parameter causes a service restart.
    MaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
    MaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
    MaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
    MaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
    MaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
    MaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
    MaxPreparedTransactions int
    PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
    MaxReplicationSlots int
    PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
    MaxSlotWalKeepSize int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. If -1 is specified, replication slots may retain an unlimited amount of WAL files. The default is -1 (upstream default). wal_keep_size minimum WAL size setting takes precedence over this.
    MaxStackDepth int
    Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
    MaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds. The default is 30000 (upstream default).
    MaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
    MaxSyncWorkersPerSubscription int
    Maximum number of synchronization workers per subscription. The default is 2.
    MaxWalSenders int
    PostgreSQL maximum WAL senders. The default is 20. Changing this parameter causes a service restart.
    MaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
    Migration UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    PasswordEncryption string
    Chooses the algorithm for encrypting passwords.
    PgPartmanBgwInterval int
    Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is 3600.
    PgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    PgStatMonitorEnable bool
    Enable pg_stat_monitor extension if available for the current cluster. Enable the pg_stat_monitor extension. Changing this parameter causes a service restart. When this extension is enabled, pg_stat_statements results for utility commands are unreliable.
    PgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    PgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    PgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
    Pgaudit UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPgaudit
    PGAudit settings. System-wide settings for the pgaudit extension.
    Pgbouncer UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    Pglookout UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    PublicAccess bool
    Public Access. Allow access to the service from the public Internet.
    ServiceLog bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    SharedBuffersPercentage double
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. Changing this parameter causes a service restart.
    SynchronousReplication string
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    TempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    Timescaledb UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    Timezone string
    PostgreSQL service timezone.
    TrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
    TrackCommitTimestamp string
    Record commit time of transactions. Changing this parameter causes a service restart.
    TrackFunctions string
    Enables tracking of function call counts and time used.
    TrackIoTiming string
    Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    Variant string
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    Version string
    PostgreSQL major version.
    WalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    WalWriterDelay int
    WAL flush interval in milliseconds. The default is 200. Setting this parameter to a lower value may negatively impact performance.
    WorkMem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. The default is 1MB + 0.075% of total RAM (up to 32MB).
    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    AutomaticUtilityNetworkIpFilter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    AutovacuumAnalyzeScaleFactor float64
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE (e.g. 0.2 for 20% of the table size). The default is 0.2.
    AutovacuumAnalyzeThreshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50.
    AutovacuumFreezeMaxAge int
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. The system launches autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. Changing this parameter causes a service restart.
    AutovacuumMaxWorkers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. Changing this parameter causes a service restart.
    AutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds. The default is 60.
    AutovacuumVacuumCostDelay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default is 2 (upstream default).
    AutovacuumVacuumCostLimit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_limit value will be used. The default is -1 (upstream default).
    AutovacuumVacuumScaleFactor float64
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM (e.g. 0.2 for 20% of the table size). The default is 0.2.
    AutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50.
    BackupHour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    BackupMinute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    BgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. The default is 200.
    BgwriterFlushAfter int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes. Setting of 0 disables forced writeback. The default is 512.
    BgwriterLruMaxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. The default is 100.
    BgwriterLruMultiplier float64
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    DeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
    DefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
    IdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    IpFilters []string
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    Jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    LogAutovacuumMinDuration int
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one disables logging autovacuum actions. The default is 1000.
    LogErrorVerbosity string
    Controls the amount of detail written in the server log for each message that is logged.
    LogLinePrefix string
    Choose from one of the available log formats.
    LogMinDurationStatement int
    Log statements that take more than this number of milliseconds to run, -1 disables.
    LogTempFiles int
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    MaxConnections int
    PostgreSQL maximum number of concurrent connections to the database server. Changing this parameter causes a service restart.
    MaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
    MaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
    MaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
    MaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
    MaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
    MaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
    MaxPreparedTransactions int
    PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
    MaxReplicationSlots int
    PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
    MaxSlotWalKeepSize int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. If -1 is specified, replication slots may retain an unlimited amount of WAL files. The default is -1 (upstream default). wal_keep_size minimum WAL size setting takes precedence over this.
    MaxStackDepth int
    Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
    MaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds. The default is 30000 (upstream default).
    MaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
    MaxSyncWorkersPerSubscription int
    Maximum number of synchronization workers per subscription. The default is 2.
    MaxWalSenders int
    PostgreSQL maximum WAL senders. The default is 20. Changing this parameter causes a service restart.
    MaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
    Migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    PasswordEncryption string
    Chooses the algorithm for encrypting passwords.
    PgPartmanBgwInterval int
    Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is 3600.
    PgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    PgStatMonitorEnable bool
    Enable pg_stat_monitor extension if available for the current cluster. Enable the pg_stat_monitor extension. Changing this parameter causes a service restart. When this extension is enabled, pg_stat_statements results for utility commands are unreliable.
    PgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    PgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    PgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
    Pgaudit ManagedDatabasePostgresqlPropertiesPgaudit
    PGAudit settings. System-wide settings for the pgaudit extension.
    Pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    Pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    PublicAccess bool
    Public Access. Allow access to the service from the public Internet.
    ServiceLog bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    SharedBuffersPercentage float64
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. Changing this parameter causes a service restart.
    SynchronousReplication string
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    TempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    Timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    Timezone string
    PostgreSQL service timezone.
    TrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
    TrackCommitTimestamp string
    Record commit time of transactions. Changing this parameter causes a service restart.
    TrackFunctions string
    Enables tracking of function call counts and time used.
    TrackIoTiming string
    Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    Variant string
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    Version string
    PostgreSQL major version.
    WalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    WalWriterDelay int
    WAL flush interval in milliseconds. The default is 200. Setting this parameter to a lower value may negatively impact performance.
    WorkMem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. The default is 1MB + 0.075% of total RAM (up to 32MB).
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter Boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuumAnalyzeScaleFactor Double
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuumAnalyzeThreshold Integer
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50.
    autovacuumFreezeMaxAge Integer
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. The system launches autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. Changing this parameter causes a service restart.
    autovacuumMaxWorkers Integer
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. Changing this parameter causes a service restart.
    autovacuumNaptime Integer
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds. The default is 60.
    autovacuumVacuumCostDelay Integer
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default is 2 (upstream default).
    autovacuumVacuumCostLimit Integer
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_limit value will be used. The default is -1 (upstream default).
    autovacuumVacuumScaleFactor Double
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuumVacuumThreshold Integer
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50.
    backupHour Integer
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute Integer
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriterDelay Integer
    Specifies the delay between activity rounds for the background writer in milliseconds. The default is 200.
    bgwriterFlushAfter Integer
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes. Setting of 0 disables forced writeback. The default is 512.
    bgwriterLruMaxpages Integer
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. The default is 100.
    bgwriterLruMultiplier Double
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    deadlockTimeout Integer
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
    defaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
    idleInTransactionSessionTimeout Integer
    Time out sessions with open transactions after this number of milliseconds.
    ipFilters List<String>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    logAutovacuumMinDuration Integer
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one disables logging autovacuum actions. The default is 1000.
    logErrorVerbosity String
    Controls the amount of detail written in the server log for each message that is logged.
    logLinePrefix String
    Choose from one of the available log formats.
    logMinDurationStatement Integer
    Log statements that take more than this number of milliseconds to run, -1 disables.
    logTempFiles Integer
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    maxConnections Integer
    PostgreSQL maximum number of concurrent connections to the database server. Changing this parameter causes a service restart.
    maxFilesPerProcess Integer
    PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
    maxLocksPerTransaction Integer
    PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
    maxLogicalReplicationWorkers Integer
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
    maxParallelWorkers Integer
    Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
    maxParallelWorkersPerGather Integer
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
    maxPredLocksPerTransaction Integer
    PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
    maxPreparedTransactions Integer
    PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
    maxReplicationSlots Integer
    PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
    maxSlotWalKeepSize Integer
    PostgreSQL maximum WAL size (MB) reserved for replication slots. If -1 is specified, replication slots may retain an unlimited amount of WAL files. The default is -1 (upstream default). wal_keep_size minimum WAL size setting takes precedence over this.
    maxStackDepth Integer
    Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
    maxStandbyArchiveDelay Integer
    Max standby archive delay in milliseconds. The default is 30000 (upstream default).
    maxStandbyStreamingDelay Integer
    Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
    maxSyncWorkersPerSubscription Integer
    Maximum number of synchronization workers per subscription. The default is 2.
    maxWalSenders Integer
    PostgreSQL maximum WAL senders. The default is 20. Changing this parameter causes a service restart.
    maxWorkerProcesses Integer
    Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
    migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    passwordEncryption String
    Chooses the algorithm for encrypting passwords.
    pgPartmanBgwInterval Integer
    Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is 3600.
    pgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    pgStatMonitorEnable Boolean
    Enable pg_stat_monitor extension if available for the current cluster. Enable the pg_stat_monitor extension. Changing this parameter causes a service restart. When this extension is enabled, pg_stat_statements results for utility commands are unreliable.
    pgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pgStatMonitorPgsmMaxBuckets Integer
    Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pgStatStatementsTrack String
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
    pgaudit ManagedDatabasePostgresqlPropertiesPgaudit
    PGAudit settings. System-wide settings for the pgaudit extension.
    pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    publicAccess Boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog Boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    sharedBuffersPercentage Double
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. Changing this parameter causes a service restart.
    synchronousReplication String
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    tempFileLimit Integer
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone String
    PostgreSQL service timezone.
    trackActivityQuerySize Integer
    Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
    trackCommitTimestamp String
    Record commit time of transactions. Changing this parameter causes a service restart.
    trackFunctions String
    Enables tracking of function call counts and time used.
    trackIoTiming String
    Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    variant String
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version String
    PostgreSQL major version.
    walSenderTimeout Integer
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    walWriterDelay Integer
    WAL flush interval in milliseconds. The default is 200. Setting this parameter to a lower value may negatively impact performance.
    workMem Integer
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. The default is 1MB + 0.075% of total RAM (up to 32MB).
    adminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuumAnalyzeScaleFactor number
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuumAnalyzeThreshold number
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50.
    autovacuumFreezeMaxAge number
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. The system launches autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. Changing this parameter causes a service restart.
    autovacuumMaxWorkers number
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. Changing this parameter causes a service restart.
    autovacuumNaptime number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds. The default is 60.
    autovacuumVacuumCostDelay number
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default is 2 (upstream default).
    autovacuumVacuumCostLimit number
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_limit value will be used. The default is -1 (upstream default).
    autovacuumVacuumScaleFactor number
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuumVacuumThreshold number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50.
    backupHour number
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute number
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriterDelay number
    Specifies the delay between activity rounds for the background writer in milliseconds. The default is 200.
    bgwriterFlushAfter number
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes. Setting of 0 disables forced writeback. The default is 512.
    bgwriterLruMaxpages number
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. The default is 100.
    bgwriterLruMultiplier number
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    deadlockTimeout number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
    defaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
    idleInTransactionSessionTimeout number
    Time out sessions with open transactions after this number of milliseconds.
    ipFilters string[]
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    logAutovacuumMinDuration number
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one disables logging autovacuum actions. The default is 1000.
    logErrorVerbosity string
    Controls the amount of detail written in the server log for each message that is logged.
    logLinePrefix string
    Choose from one of the available log formats.
    logMinDurationStatement number
    Log statements that take more than this number of milliseconds to run, -1 disables.
    logTempFiles number
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    maxConnections number
    PostgreSQL maximum number of concurrent connections to the database server. Changing this parameter causes a service restart.
    maxFilesPerProcess number
    PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
    maxLocksPerTransaction number
    PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
    maxLogicalReplicationWorkers number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
    maxParallelWorkers number
    Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
    maxParallelWorkersPerGather number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
    maxPredLocksPerTransaction number
    PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
    maxPreparedTransactions number
    PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
    maxReplicationSlots number
    PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
    maxSlotWalKeepSize number
    PostgreSQL maximum WAL size (MB) reserved for replication slots. If -1 is specified, replication slots may retain an unlimited amount of WAL files. The default is -1 (upstream default). wal_keep_size minimum WAL size setting takes precedence over this.
    maxStackDepth number
    Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
    maxStandbyArchiveDelay number
    Max standby archive delay in milliseconds. The default is 30000 (upstream default).
    maxStandbyStreamingDelay number
    Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
    maxSyncWorkersPerSubscription number
    Maximum number of synchronization workers per subscription. The default is 2.
    maxWalSenders number
    PostgreSQL maximum WAL senders. The default is 20. Changing this parameter causes a service restart.
    maxWorkerProcesses number
    Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
    migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    passwordEncryption string
    Chooses the algorithm for encrypting passwords.
    pgPartmanBgwInterval number
    Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is 3600.
    pgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    pgStatMonitorEnable boolean
    Enable pg_stat_monitor extension if available for the current cluster. Enable the pg_stat_monitor extension. Changing this parameter causes a service restart. When this extension is enabled, pg_stat_statements results for utility commands are unreliable.
    pgStatMonitorPgsmEnableQueryPlan boolean
    Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pgStatMonitorPgsmMaxBuckets number
    Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
    pgaudit ManagedDatabasePostgresqlPropertiesPgaudit
    PGAudit settings. System-wide settings for the pgaudit extension.
    pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    publicAccess boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    sharedBuffersPercentage number
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. Changing this parameter causes a service restart.
    synchronousReplication string
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    tempFileLimit number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone string
    PostgreSQL service timezone.
    trackActivityQuerySize number
    Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
    trackCommitTimestamp string
    Record commit time of transactions. Changing this parameter causes a service restart.
    trackFunctions string
    Enables tracking of function call counts and time used.
    trackIoTiming string
    Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    variant string
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version string
    PostgreSQL major version.
    walSenderTimeout number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    walWriterDelay number
    WAL flush interval in milliseconds. The default is 200. Setting this parameter to a lower value may negatively impact performance.
    workMem number
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. The default is 1MB + 0.075% of total RAM (up to 32MB).
    admin_password str
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    admin_username str
    Custom username for admin user. This must be set only when a new service is being created.
    automatic_utility_network_ip_filter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuum_analyze_scale_factor float
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuum_analyze_threshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50.
    autovacuum_freeze_max_age int
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. The system launches autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. Changing this parameter causes a service restart.
    autovacuum_max_workers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. Changing this parameter causes a service restart.
    autovacuum_naptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds. The default is 60.
    autovacuum_vacuum_cost_delay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default is 2 (upstream default).
    autovacuum_vacuum_cost_limit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_limit value will be used. The default is -1 (upstream default).
    autovacuum_vacuum_scale_factor float
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuum_vacuum_threshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50.
    backup_hour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backup_minute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriter_delay int
    Specifies the delay between activity rounds for the background writer in milliseconds. The default is 200.
    bgwriter_flush_after int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes. Setting of 0 disables forced writeback. The default is 512.
    bgwriter_lru_maxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. The default is 100.
    bgwriter_lru_multiplier float
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    deadlock_timeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
    default_toast_compression str
    Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
    idle_in_transaction_session_timeout int
    Time out sessions with open transactions after this number of milliseconds.
    ip_filters Sequence[str]
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    log_autovacuum_min_duration int
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one disables logging autovacuum actions. The default is 1000.
    log_error_verbosity str
    Controls the amount of detail written in the server log for each message that is logged.
    log_line_prefix str
    Choose from one of the available log formats.
    log_min_duration_statement int
    Log statements that take more than this number of milliseconds to run, -1 disables.
    log_temp_files int
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    max_connections int
    PostgreSQL maximum number of concurrent connections to the database server. Changing this parameter causes a service restart.
    max_files_per_process int
    PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
    max_locks_per_transaction int
    PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
    max_logical_replication_workers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
    max_parallel_workers int
    Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
    max_parallel_workers_per_gather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
    max_pred_locks_per_transaction int
    PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
    max_prepared_transactions int
    PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
    max_replication_slots int
    PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
    max_slot_wal_keep_size int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. If -1 is specified, replication slots may retain an unlimited amount of WAL files. The default is -1 (upstream default). wal_keep_size minimum WAL size setting takes precedence over this.
    max_stack_depth int
    Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
    max_standby_archive_delay int
    Max standby archive delay in milliseconds. The default is 30000 (upstream default).
    max_standby_streaming_delay int
    Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
    max_sync_workers_per_subscription int
    Maximum number of synchronization workers per subscription. The default is 2.
    max_wal_senders int
    PostgreSQL maximum WAL senders. The default is 20. Changing this parameter causes a service restart.
    max_worker_processes int
    Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
    migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    password_encryption str
    Chooses the algorithm for encrypting passwords.
    pg_partman_bgw_interval int
    Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is 3600.
    pg_partman_bgw_role str
    Controls which role to use for pg_partman's scheduled background tasks.
    pg_stat_monitor_enable bool
    Enable pg_stat_monitor extension if available for the current cluster. Enable the pg_stat_monitor extension. Changing this parameter causes a service restart. When this extension is enabled, pg_stat_statements results for utility commands are unreliable.
    pg_stat_monitor_pgsm_enable_query_plan bool
    Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pg_stat_monitor_pgsm_max_buckets int
    Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pg_stat_statements_track str
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
    pgaudit ManagedDatabasePostgresqlPropertiesPgaudit
    PGAudit settings. System-wide settings for the pgaudit extension.
    pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    public_access bool
    Public Access. Allow access to the service from the public Internet.
    service_log bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    shared_buffers_percentage float
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. Changing this parameter causes a service restart.
    synchronous_replication str
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    temp_file_limit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone str
    PostgreSQL service timezone.
    track_activity_query_size int
    Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
    track_commit_timestamp str
    Record commit time of transactions. Changing this parameter causes a service restart.
    track_functions str
    Enables tracking of function call counts and time used.
    track_io_timing str
    Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    variant str
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version str
    PostgreSQL major version.
    wal_sender_timeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    wal_writer_delay int
    WAL flush interval in milliseconds. The default is 200. Setting this parameter to a lower value may negatively impact performance.
    work_mem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. The default is 1MB + 0.075% of total RAM (up to 32MB).
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter Boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuumAnalyzeScaleFactor Number
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuumAnalyzeThreshold Number
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50.
    autovacuumFreezeMaxAge Number
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. The system launches autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. Changing this parameter causes a service restart.
    autovacuumMaxWorkers Number
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is 3. Changing this parameter causes a service restart.
    autovacuumNaptime Number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds. The default is 60.
    autovacuumVacuumCostDelay Number
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default is 2 (upstream default).
    autovacuumVacuumCostLimit Number
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_limit value will be used. The default is -1 (upstream default).
    autovacuumVacuumScaleFactor Number
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM (e.g. 0.2 for 20% of the table size). The default is 0.2.
    autovacuumVacuumThreshold Number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50.
    backupHour Number
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute Number
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriterDelay Number
    Specifies the delay between activity rounds for the background writer in milliseconds. The default is 200.
    bgwriterFlushAfter Number
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes. Setting of 0 disables forced writeback. The default is 512.
    bgwriterLruMaxpages Number
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. The default is 100.
    bgwriterLruMultiplier Number
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    deadlockTimeout Number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition. The default is 1000 (upstream default).
    defaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns. The default is lz4. Only available for PostgreSQL 14+.
    idleInTransactionSessionTimeout Number
    Time out sessions with open transactions after this number of milliseconds.
    ipFilters List<String>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    logAutovacuumMinDuration Number
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one disables logging autovacuum actions. The default is 1000.
    logErrorVerbosity String
    Controls the amount of detail written in the server log for each message that is logged.
    logLinePrefix String
    Choose from one of the available log formats.
    logMinDurationStatement Number
    Log statements that take more than this number of milliseconds to run, -1 disables.
    logTempFiles Number
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    maxConnections Number
    PostgreSQL maximum number of concurrent connections to the database server. Changing this parameter causes a service restart.
    maxFilesPerProcess Number
    PostgreSQL maximum number of files that can be open per process. The default is 1000 (upstream default). Changing this parameter causes a service restart.
    maxLocksPerTransaction Number
    PostgreSQL maximum locks per transaction. Changing this parameter causes a service restart.
    maxLogicalReplicationWorkers Number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers). The default is 4 (upstream default). Changing this parameter causes a service restart.
    maxParallelWorkers Number
    Sets the maximum number of workers that the system can support for parallel queries. The default is 8 (upstream default).
    maxParallelWorkersPerGather Number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node. The default is 2 (upstream default).
    maxPredLocksPerTransaction Number
    PostgreSQL maximum predicate locks per transaction. The default is 64 (upstream default). Changing this parameter causes a service restart.
    maxPreparedTransactions Number
    PostgreSQL maximum prepared transactions. The default is 0. Changing this parameter causes a service restart.
    maxReplicationSlots Number
    PostgreSQL maximum replication slots. The default is 20. Changing this parameter causes a service restart.
    maxSlotWalKeepSize Number
    PostgreSQL maximum WAL size (MB) reserved for replication slots. If -1 is specified, replication slots may retain an unlimited amount of WAL files. The default is -1 (upstream default). wal_keep_size minimum WAL size setting takes precedence over this.
    maxStackDepth Number
    Maximum depth of the stack in bytes. The default is 2097152 (upstream default).
    maxStandbyArchiveDelay Number
    Max standby archive delay in milliseconds. The default is 30000 (upstream default).
    maxStandbyStreamingDelay Number
    Max standby streaming delay in milliseconds. The default is 30000 (upstream default).
    maxSyncWorkersPerSubscription Number
    Maximum number of synchronization workers per subscription. The default is 2.
    maxWalSenders Number
    PostgreSQL maximum WAL senders. The default is 20. Changing this parameter causes a service restart.
    maxWorkerProcesses Number
    Sets the maximum number of background processes that the system can support. The default is 8. Changing this parameter causes a service restart.
    migration Property Map
    Migrate data from existing server.
    passwordEncryption String
    Chooses the algorithm for encrypting passwords.
    pgPartmanBgwInterval Number
    Sets the time interval in seconds to run pg_partman's scheduled tasks. The default is 3600.
    pgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    pgStatMonitorEnable Boolean
    Enable pg_stat_monitor extension if available for the current cluster. Enable the pg_stat_monitor extension. Changing this parameter causes a service restart. When this extension is enabled, pg_stat_statements results for utility commands are unreliable.
    pgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pgStatMonitorPgsmMaxBuckets Number
    Sets the maximum number of buckets. Changing this parameter causes a service restart. Only available for PostgreSQL 13+.
    pgStatStatementsTrack String
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default is top.
    pgaudit Property Map
    PGAudit settings. System-wide settings for the pgaudit extension.
    pgbouncer Property Map
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout Property Map
    PGLookout settings. System-wide settings for pglookout.
    publicAccess Boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog Boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    sharedBuffersPercentage Number
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value. Changing this parameter causes a service restart.
    synchronousReplication String
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    tempFileLimit Number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb Property Map
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone String
    PostgreSQL service timezone.
    trackActivityQuerySize Number
    Specifies the number of bytes reserved to track the currently executing command for each active session. Changing this parameter causes a service restart.
    trackCommitTimestamp String
    Record commit time of transactions. Changing this parameter causes a service restart.
    trackFunctions String
    Enables tracking of function call counts and time used.
    trackIoTiming String
    Enables timing of database I/O calls. The default is off. When on, it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    variant String
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version String
    PostgreSQL major version.
    walSenderTimeout Number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    walWriterDelay Number
    WAL flush interval in milliseconds. The default is 200. Setting this parameter to a lower value may negatively impact performance.
    workMem Number
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. The default is 1MB + 0.075% of total RAM (up to 32MB).

    ManagedDatabasePostgresqlPropertiesMigration, ManagedDatabasePostgresqlPropertiesMigrationArgs

    Dbname string
    Database name for bootstrapping the initial connection.
    Host string
    Hostname or IP address of the server where to migrate data from.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    IgnoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    Method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Ssl bool
    The server where to migrate data from is secured with SSL.
    Username string
    User name for authentication with the server where to migrate data from.
    Dbname string
    Database name for bootstrapping the initial connection.
    Host string
    Hostname or IP address of the server where to migrate data from.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    IgnoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    Method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Ssl bool
    The server where to migrate data from is secured with SSL.
    Username string
    User name for authentication with the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    host String
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles String
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method String
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from.
    port Integer
    Port number of the server where to migrate data from.
    ssl Boolean
    The server where to migrate data from is secured with SSL.
    username String
    User name for authentication with the server where to migrate data from.
    dbname string
    Database name for bootstrapping the initial connection.
    host string
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password string
    Password for authentication with the server where to migrate data from.
    port number
    Port number of the server where to migrate data from.
    ssl boolean
    The server where to migrate data from is secured with SSL.
    username string
    User name for authentication with the server where to migrate data from.
    dbname str
    Database name for bootstrapping the initial connection.
    host str
    Hostname or IP address of the server where to migrate data from.
    ignore_dbs str
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignore_roles str
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method str
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password str
    Password for authentication with the server where to migrate data from.
    port int
    Port number of the server where to migrate data from.
    ssl bool
    The server where to migrate data from is secured with SSL.
    username str
    User name for authentication with the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    host String
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles String
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method String
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from.
    port Number
    Port number of the server where to migrate data from.
    ssl Boolean
    The server where to migrate data from is secured with SSL.
    username String
    User name for authentication with the server where to migrate data from.

    ManagedDatabasePostgresqlPropertiesPgaudit, ManagedDatabasePostgresqlPropertiesPgauditArgs

    FeatureEnabled bool
    Enable pgaudit extension. Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved.
    LogCatalog bool
    Specifies that session logging should be enabled in the casewhere all relations in a statement are in pg_catalog.
    LogClient bool
    Specifies whether log messages will be visible to a client process such as psql.
    LogLevel string
    Specifies the log level that will be used for log entries.
    LogMaxStringLength int
    Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation.
    LogNestedStatements bool
    This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun.
    LogParameter bool
    Specifies that audit logging should include the parameters that were passed with the statement.
    LogParameterMaxSize int
    Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with .
    LogRelation bool
    Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.
    LogRows bool
    Specifies that audit logging should include the rows retrieved or affected by a statement. When enabled the rows field will be included after the parameter field.
    LogStatement bool
    Specifies whether logging will include the statement text and parameters (if enabled).
    LogStatementOnce bool
    Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.
    Logs List<string>
    Specifies which classes of statements will be logged by session audit logging.
    Role string
    Specifies the master role to use for object audit logging.
    FeatureEnabled bool
    Enable pgaudit extension. Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved.
    LogCatalog bool
    Specifies that session logging should be enabled in the casewhere all relations in a statement are in pg_catalog.
    LogClient bool
    Specifies whether log messages will be visible to a client process such as psql.
    LogLevel string
    Specifies the log level that will be used for log entries.
    LogMaxStringLength int
    Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation.
    LogNestedStatements bool
    This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun.
    LogParameter bool
    Specifies that audit logging should include the parameters that were passed with the statement.
    LogParameterMaxSize int
    Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with .
    LogRelation bool
    Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.
    LogRows bool
    Specifies that audit logging should include the rows retrieved or affected by a statement. When enabled the rows field will be included after the parameter field.
    LogStatement bool
    Specifies whether logging will include the statement text and parameters (if enabled).
    LogStatementOnce bool
    Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.
    Logs []string
    Specifies which classes of statements will be logged by session audit logging.
    Role string
    Specifies the master role to use for object audit logging.
    featureEnabled Boolean
    Enable pgaudit extension. Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved.
    logCatalog Boolean
    Specifies that session logging should be enabled in the casewhere all relations in a statement are in pg_catalog.
    logClient Boolean
    Specifies whether log messages will be visible to a client process such as psql.
    logLevel String
    Specifies the log level that will be used for log entries.
    logMaxStringLength Integer
    Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation.
    logNestedStatements Boolean
    This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun.
    logParameter Boolean
    Specifies that audit logging should include the parameters that were passed with the statement.
    logParameterMaxSize Integer
    Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with .
    logRelation Boolean
    Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.
    logRows Boolean
    Specifies that audit logging should include the rows retrieved or affected by a statement. When enabled the rows field will be included after the parameter field.
    logStatement Boolean
    Specifies whether logging will include the statement text and parameters (if enabled).
    logStatementOnce Boolean
    Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.
    logs List<String>
    Specifies which classes of statements will be logged by session audit logging.
    role String
    Specifies the master role to use for object audit logging.
    featureEnabled boolean
    Enable pgaudit extension. Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved.
    logCatalog boolean
    Specifies that session logging should be enabled in the casewhere all relations in a statement are in pg_catalog.
    logClient boolean
    Specifies whether log messages will be visible to a client process such as psql.
    logLevel string
    Specifies the log level that will be used for log entries.
    logMaxStringLength number
    Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation.
    logNestedStatements boolean
    This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun.
    logParameter boolean
    Specifies that audit logging should include the parameters that were passed with the statement.
    logParameterMaxSize number
    Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with .
    logRelation boolean
    Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.
    logRows boolean
    Specifies that audit logging should include the rows retrieved or affected by a statement. When enabled the rows field will be included after the parameter field.
    logStatement boolean
    Specifies whether logging will include the statement text and parameters (if enabled).
    logStatementOnce boolean
    Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.
    logs string[]
    Specifies which classes of statements will be logged by session audit logging.
    role string
    Specifies the master role to use for object audit logging.
    feature_enabled bool
    Enable pgaudit extension. Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved.
    log_catalog bool
    Specifies that session logging should be enabled in the casewhere all relations in a statement are in pg_catalog.
    log_client bool
    Specifies whether log messages will be visible to a client process such as psql.
    log_level str
    Specifies the log level that will be used for log entries.
    log_max_string_length int
    Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation.
    log_nested_statements bool
    This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun.
    log_parameter bool
    Specifies that audit logging should include the parameters that were passed with the statement.
    log_parameter_max_size int
    Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with .
    log_relation bool
    Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.
    log_rows bool
    Specifies that audit logging should include the rows retrieved or affected by a statement. When enabled the rows field will be included after the parameter field.
    log_statement bool
    Specifies whether logging will include the statement text and parameters (if enabled).
    log_statement_once bool
    Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.
    logs Sequence[str]
    Specifies which classes of statements will be logged by session audit logging.
    role str
    Specifies the master role to use for object audit logging.
    featureEnabled Boolean
    Enable pgaudit extension. Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved.
    logCatalog Boolean
    Specifies that session logging should be enabled in the casewhere all relations in a statement are in pg_catalog.
    logClient Boolean
    Specifies whether log messages will be visible to a client process such as psql.
    logLevel String
    Specifies the log level that will be used for log entries.
    logMaxStringLength Number
    Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation.
    logNestedStatements Boolean
    This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun.
    logParameter Boolean
    Specifies that audit logging should include the parameters that were passed with the statement.
    logParameterMaxSize Number
    Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with .
    logRelation Boolean
    Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement.
    logRows Boolean
    Specifies that audit logging should include the rows retrieved or affected by a statement. When enabled the rows field will be included after the parameter field.
    logStatement Boolean
    Specifies whether logging will include the statement text and parameters (if enabled).
    logStatementOnce Boolean
    Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry.
    logs List<String>
    Specifies which classes of statements will be logged by session audit logging.
    role String
    Specifies the master role to use for object audit logging.

    ManagedDatabasePostgresqlPropertiesPgbouncer, ManagedDatabasePostgresqlPropertiesPgbouncerArgs

    AutodbIdleTimeout int
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    AutodbMaxDbConnections int
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    AutodbPoolMode string
    PGBouncer pool mode.
    AutodbPoolSize int
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    IgnoreStartupParameters List<string>
    List of parameters to ignore when given in startup packet.
    MaxPreparedStatements int
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    MinPoolSize int
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    ServerIdleTimeout int
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    ServerLifetime int
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    ServerResetQueryAlways bool
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    AutodbIdleTimeout int
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    AutodbMaxDbConnections int
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    AutodbPoolMode string
    PGBouncer pool mode.
    AutodbPoolSize int
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    IgnoreStartupParameters []string
    List of parameters to ignore when given in startup packet.
    MaxPreparedStatements int
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    MinPoolSize int
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    ServerIdleTimeout int
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    ServerLifetime int
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    ServerResetQueryAlways bool
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodbIdleTimeout Integer
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodbMaxDbConnections Integer
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodbPoolMode String
    PGBouncer pool mode.
    autodbPoolSize Integer
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignoreStartupParameters List<String>
    List of parameters to ignore when given in startup packet.
    maxPreparedStatements Integer
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    minPoolSize Integer
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    serverIdleTimeout Integer
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    serverLifetime Integer
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    serverResetQueryAlways Boolean
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodbIdleTimeout number
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodbMaxDbConnections number
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodbPoolMode string
    PGBouncer pool mode.
    autodbPoolSize number
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignoreStartupParameters string[]
    List of parameters to ignore when given in startup packet.
    maxPreparedStatements number
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    minPoolSize number
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    serverIdleTimeout number
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    serverLifetime number
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    serverResetQueryAlways boolean
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodb_idle_timeout int
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodb_max_db_connections int
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodb_pool_mode str
    PGBouncer pool mode.
    autodb_pool_size int
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignore_startup_parameters Sequence[str]
    List of parameters to ignore when given in startup packet.
    max_prepared_statements int
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    min_pool_size int
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    server_idle_timeout int
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    server_lifetime int
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    server_reset_query_always bool
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodbIdleTimeout Number
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodbMaxDbConnections Number
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodbPoolMode String
    PGBouncer pool mode.
    autodbPoolSize Number
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignoreStartupParameters List<String>
    List of parameters to ignore when given in startup packet.
    maxPreparedStatements Number
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    minPoolSize Number
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    serverIdleTimeout Number
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    serverLifetime Number
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    serverResetQueryAlways Boolean
    Run server_reset_query (DISCARD ALL) in all pooling modes.

    ManagedDatabasePostgresqlPropertiesPglookout, ManagedDatabasePostgresqlPropertiesPglookoutArgs

    MaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby.
    MaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby.
    maxFailoverReplicationTimeLag Integer
    Number of seconds of master unavailability before triggering database failover to standby.
    maxFailoverReplicationTimeLag number
    Number of seconds of master unavailability before triggering database failover to standby.
    max_failover_replication_time_lag int
    Number of seconds of master unavailability before triggering database failover to standby.
    maxFailoverReplicationTimeLag Number
    Number of seconds of master unavailability before triggering database failover to standby.

    ManagedDatabasePostgresqlPropertiesTimescaledb, ManagedDatabasePostgresqlPropertiesTimescaledbArgs

    MaxBackgroundWorkers int
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time. Changing this parameter causes a service restart.
    MaxBackgroundWorkers int
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time. Changing this parameter causes a service restart.
    maxBackgroundWorkers Integer
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time. Changing this parameter causes a service restart.
    maxBackgroundWorkers number
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time. Changing this parameter causes a service restart.
    max_background_workers int
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time. Changing this parameter causes a service restart.
    maxBackgroundWorkers Number
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time. Changing this parameter causes a service restart.

    Package Details

    Repository
    upcloud UpCloudLtd/pulumi-upcloud
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the upcloud Terraform Provider.
    upcloud logo
    UpCloud v0.4.1 published on Friday, Jul 18, 2025 by UpCloudLtd
    UpCloudLtd/pulumi-upcloud