Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Psql
  5. getDbSystems
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.Psql.getDbSystems

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides the list of Db Systems in Oracle Cloud Infrastructure Psql service.

    Returns a list of database systems.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDbSystems = oci.Psql.getDbSystems({
    compartmentId: compartmentId,
    displayName: dbSystemDisplayName,
    id: dbSystemId,
    state: dbSystemState,
});

    import pulumi
import pulumi_oci as oci

test_db_systems = oci.Psql.get_db_systems(compartment_id=compartment_id,
    display_name=db_system_display_name,
    id=db_system_id,
    state=db_system_state)

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/psql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := psql.GetDbSystems(ctx, &psql.GetDbSystemsArgs{
			CompartmentId: pulumi.StringRef(compartmentId),
			DisplayName:   pulumi.StringRef(dbSystemDisplayName),
			Id:            pulumi.StringRef(dbSystemId),
			State:         pulumi.StringRef(dbSystemState),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var testDbSystems = Oci.Psql.GetDbSystems.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = dbSystemDisplayName,
        Id = dbSystemId,
        State = dbSystemState,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Psql.PsqlFunctions;
import com.pulumi.oci.Psql.inputs.GetDbSystemsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testDbSystems = PsqlFunctions.getDbSystems(GetDbSystemsArgs.builder()
            .compartmentId(compartmentId)
            .displayName(dbSystemDisplayName)
            .id(dbSystemId)
            .state(dbSystemState)
            .build());

    }
}

    variables:
  testDbSystems:
    fn::invoke:
      function: oci:Psql:getDbSystems
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${dbSystemDisplayName}
        id: ${dbSystemId}
        state: ${dbSystemState}

    Using getDbSystems

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

    function getDbSystems(args: GetDbSystemsArgs, opts?: InvokeOptions): Promise<GetDbSystemsResult>
function getDbSystemsOutput(args: GetDbSystemsOutputArgs, opts?: InvokeOptions): Output<GetDbSystemsResult>
    def get_db_systems(compartment_id: Optional[str] = None,
                   display_name: Optional[str] = None,
                   filters: Optional[Sequence[GetDbSystemsFilter]] = None,
                   id: Optional[str] = None,
                   state: Optional[str] = None,
                   opts: Optional[InvokeOptions] = None) -> GetDbSystemsResult
def get_db_systems_output(compartment_id: Optional[pulumi.Input[str]] = None,
                   display_name: Optional[pulumi.Input[str]] = None,
                   filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetDbSystemsFilterArgs]]]] = None,
                   id: Optional[pulumi.Input[str]] = None,
                   state: Optional[pulumi.Input[str]] = None,
                   opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemsResult]
    func GetDbSystems(ctx *Context, args *GetDbSystemsArgs, opts ...InvokeOption) (*GetDbSystemsResult, error)
func GetDbSystemsOutput(ctx *Context, args *GetDbSystemsOutputArgs, opts ...InvokeOption) GetDbSystemsResultOutput

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

    public static class GetDbSystems 
{
    public static Task<GetDbSystemsResult> InvokeAsync(GetDbSystemsArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemsResult> Invoke(GetDbSystemsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDbSystemsResult> getDbSystems(GetDbSystemsArgs args, InvokeOptions options)
public static Output<GetDbSystemsResult> getDbSystems(GetDbSystemsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:Psql/getDbSystems:getDbSystems
  arguments:
    # arguments dictionary

    The following arguments are supported:

    CompartmentId string
    The ID of the compartment in which to list resources.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    Filters List<GetDbSystemsFilter>
    Id string
    A unique identifier for the database system.
    State string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    CompartmentId string
    The ID of the compartment in which to list resources.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    Filters []GetDbSystemsFilter
    Id string
    A unique identifier for the database system.
    State string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    compartmentId String
    The ID of the compartment in which to list resources.
    displayName String
    A filter to return only resources that match the entire display name given.
    filters List<GetDbSystemsFilter>
    id String
    A unique identifier for the database system.
    state String
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    compartmentId string
    The ID of the compartment in which to list resources.
    displayName string
    A filter to return only resources that match the entire display name given.
    filters GetDbSystemsFilter[]
    id string
    A unique identifier for the database system.
    state string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    compartment_id str
    The ID of the compartment in which to list resources.
    display_name str
    A filter to return only resources that match the entire display name given.
    filters Sequence[GetDbSystemsFilter]
    id str
    A unique identifier for the database system.
    state str
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    compartmentId String
    The ID of the compartment in which to list resources.
    displayName String
    A filter to return only resources that match the entire display name given.
    filters List<Property Map>
    id String
    A unique identifier for the database system.
    state String
    A filter to return only resources if their lifecycleState matches the given lifecycleState.

    getDbSystems Result

    The following output properties are available:

    DbSystemCollections List<GetDbSystemsDbSystemCollection>
    The list of db_system_collection.
    CompartmentId string
    target compartment to place a new backup
    DisplayName string
    A user-friendly display name for the database instance node. Avoid entering confidential information.
    Filters List<GetDbSystemsFilter>
    Id string
    A unique identifier for the database instance node. Immutable on creation.
    State string
    The current state of the database system.
    DbSystemCollections []GetDbSystemsDbSystemCollection
    The list of db_system_collection.
    CompartmentId string
    target compartment to place a new backup
    DisplayName string
    A user-friendly display name for the database instance node. Avoid entering confidential information.
    Filters []GetDbSystemsFilter
    Id string
    A unique identifier for the database instance node. Immutable on creation.
    State string
    The current state of the database system.
    dbSystemCollections List<GetDbSystemsDbSystemCollection>
    The list of db_system_collection.
    compartmentId String
    target compartment to place a new backup
    displayName String
    A user-friendly display name for the database instance node. Avoid entering confidential information.
    filters List<GetDbSystemsFilter>
    id String
    A unique identifier for the database instance node. Immutable on creation.
    state String
    The current state of the database system.
    dbSystemCollections GetDbSystemsDbSystemCollection[]
    The list of db_system_collection.
    compartmentId string
    target compartment to place a new backup
    displayName string
    A user-friendly display name for the database instance node. Avoid entering confidential information.
    filters GetDbSystemsFilter[]
    id string
    A unique identifier for the database instance node. Immutable on creation.
    state string
    The current state of the database system.
    db_system_collections Sequence[GetDbSystemsDbSystemCollection]
    The list of db_system_collection.
    compartment_id str
    target compartment to place a new backup
    display_name str
    A user-friendly display name for the database instance node. Avoid entering confidential information.
    filters Sequence[GetDbSystemsFilter]
    id str
    A unique identifier for the database instance node. Immutable on creation.
    state str
    The current state of the database system.
    dbSystemCollections List<Property Map>
    The list of db_system_collection.
    compartmentId String
    target compartment to place a new backup
    displayName String
    A user-friendly display name for the database instance node. Avoid entering confidential information.
    filters List<Property Map>
    id String
    A unique identifier for the database instance node. Immutable on creation.
    state String
    The current state of the database system.

    Supporting Types

    GetDbSystemsDbSystemCollection

    GetDbSystemsDbSystemCollectionItem

    AdminUsername string
    The database system administrator username.
    ApplyConfig string
    CompartmentId string
    The ID of the compartment in which to list resources.
    ConfigId string
    The OCID of the configuration associated with the database system.
    Credentials List<GetDbSystemsDbSystemCollectionItemCredential>
    DbVersion string
    The major and minor versions of the database system software.
    DefinedTags Dictionary<string, string>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    Description of the database instance node.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    FreeformTags Dictionary<string, string>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Id string
    A unique identifier for the database system.
    InstanceCount int
    Count of instances, or nodes, in the database system.
    InstanceMemorySizeInGbs int
    The total amount of memory available to each database instance node, in gigabytes.
    InstanceOcpuCount int
    The total number of OCPUs available to each database instance node.
    Instances List<GetDbSystemsDbSystemCollectionItemInstance>
    The list of instances, or nodes, in the database system.
    InstancesDetails List<GetDbSystemsDbSystemCollectionItemInstancesDetail>
    LifecycleDetails string
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    ManagementPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicy>
    PostgreSQL database system management policy.
    NetworkDetails List<GetDbSystemsDbSystemCollectionItemNetworkDetail>
    Network details for the database system.
    PatchOperations List<GetDbSystemsDbSystemCollectionItemPatchOperation>
    Shape string
    The name of the shape for the database instance. Example: VM.Standard.E4.Flex
    Sources List<GetDbSystemsDbSystemCollectionItemSource>
    The source used to restore the database system.
    State string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    StorageDetails List<GetDbSystemsDbSystemCollectionItemStorageDetail>
    Storage details of the database system.
    SystemTags Dictionary<string, string>
    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
    SystemType string
    Type of the database system.
    TimeCreated string
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    TimeUpdated string
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    AdminUsername string
    The database system administrator username.
    ApplyConfig string
    CompartmentId string
    The ID of the compartment in which to list resources.
    ConfigId string
    The OCID of the configuration associated with the database system.
    Credentials []GetDbSystemsDbSystemCollectionItemCredential
    DbVersion string
    The major and minor versions of the database system software.
    DefinedTags map[string]string
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    Description of the database instance node.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    FreeformTags map[string]string
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Id string
    A unique identifier for the database system.
    InstanceCount int
    Count of instances, or nodes, in the database system.
    InstanceMemorySizeInGbs int
    The total amount of memory available to each database instance node, in gigabytes.
    InstanceOcpuCount int
    The total number of OCPUs available to each database instance node.
    Instances []GetDbSystemsDbSystemCollectionItemInstance
    The list of instances, or nodes, in the database system.
    InstancesDetails []GetDbSystemsDbSystemCollectionItemInstancesDetail
    LifecycleDetails string
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    ManagementPolicies []GetDbSystemsDbSystemCollectionItemManagementPolicy
    PostgreSQL database system management policy.
    NetworkDetails []GetDbSystemsDbSystemCollectionItemNetworkDetail
    Network details for the database system.
    PatchOperations []GetDbSystemsDbSystemCollectionItemPatchOperation
    Shape string
    The name of the shape for the database instance. Example: VM.Standard.E4.Flex
    Sources []GetDbSystemsDbSystemCollectionItemSource
    The source used to restore the database system.
    State string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    StorageDetails []GetDbSystemsDbSystemCollectionItemStorageDetail
    Storage details of the database system.
    SystemTags map[string]string
    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
    SystemType string
    Type of the database system.
    TimeCreated string
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    TimeUpdated string
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    adminUsername String
    The database system administrator username.
    applyConfig String
    compartmentId String
    The ID of the compartment in which to list resources.
    configId String
    The OCID of the configuration associated with the database system.
    credentials List<GetDbSystemsDbSystemCollectionItemCredential>
    dbVersion String
    The major and minor versions of the database system software.
    definedTags Map<String,String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    Description of the database instance node.
    displayName String
    A filter to return only resources that match the entire display name given.
    freeformTags Map<String,String>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id String
    A unique identifier for the database system.
    instanceCount Integer
    Count of instances, or nodes, in the database system.
    instanceMemorySizeInGbs Integer
    The total amount of memory available to each database instance node, in gigabytes.
    instanceOcpuCount Integer
    The total number of OCPUs available to each database instance node.
    instances List<GetDbSystemsDbSystemCollectionItemInstance>
    The list of instances, or nodes, in the database system.
    instancesDetails List<GetDbSystemsDbSystemCollectionItemInstancesDetail>
    lifecycleDetails String
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    managementPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicy>
    PostgreSQL database system management policy.
    networkDetails List<GetDbSystemsDbSystemCollectionItemNetworkDetail>
    Network details for the database system.
    patchOperations List<GetDbSystemsDbSystemCollectionItemPatchOperation>
    shape String
    The name of the shape for the database instance. Example: VM.Standard.E4.Flex
    sources List<GetDbSystemsDbSystemCollectionItemSource>
    The source used to restore the database system.
    state String
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    storageDetails List<GetDbSystemsDbSystemCollectionItemStorageDetail>
    Storage details of the database system.
    systemTags Map<String,String>
    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
    systemType String
    Type of the database system.
    timeCreated String
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    timeUpdated String
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    adminUsername string
    The database system administrator username.
    applyConfig string
    compartmentId string
    The ID of the compartment in which to list resources.
    configId string
    The OCID of the configuration associated with the database system.
    credentials GetDbSystemsDbSystemCollectionItemCredential[]
    dbVersion string
    The major and minor versions of the database system software.
    definedTags {[key: string]: string}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    Description of the database instance node.
    displayName string
    A filter to return only resources that match the entire display name given.
    freeformTags {[key: string]: string}
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id string
    A unique identifier for the database system.
    instanceCount number
    Count of instances, or nodes, in the database system.
    instanceMemorySizeInGbs number
    The total amount of memory available to each database instance node, in gigabytes.
    instanceOcpuCount number
    The total number of OCPUs available to each database instance node.
    instances GetDbSystemsDbSystemCollectionItemInstance[]
    The list of instances, or nodes, in the database system.
    instancesDetails GetDbSystemsDbSystemCollectionItemInstancesDetail[]
    lifecycleDetails string
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    managementPolicies GetDbSystemsDbSystemCollectionItemManagementPolicy[]
    PostgreSQL database system management policy.
    networkDetails GetDbSystemsDbSystemCollectionItemNetworkDetail[]
    Network details for the database system.
    patchOperations GetDbSystemsDbSystemCollectionItemPatchOperation[]
    shape string
    The name of the shape for the database instance. Example: VM.Standard.E4.Flex
    sources GetDbSystemsDbSystemCollectionItemSource[]
    The source used to restore the database system.
    state string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    storageDetails GetDbSystemsDbSystemCollectionItemStorageDetail[]
    Storage details of the database system.
    systemTags {[key: string]: string}
    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
    systemType string
    Type of the database system.
    timeCreated string
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    timeUpdated string
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    admin_username str
    The database system administrator username.
    apply_config str
    compartment_id str
    The ID of the compartment in which to list resources.
    config_id str
    The OCID of the configuration associated with the database system.
    credentials Sequence[GetDbSystemsDbSystemCollectionItemCredential]
    db_version str
    The major and minor versions of the database system software.
    defined_tags Mapping[str, str]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    Description of the database instance node.
    display_name str
    A filter to return only resources that match the entire display name given.
    freeform_tags Mapping[str, str]
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id str
    A unique identifier for the database system.
    instance_count int
    Count of instances, or nodes, in the database system.
    instance_memory_size_in_gbs int
    The total amount of memory available to each database instance node, in gigabytes.
    instance_ocpu_count int
    The total number of OCPUs available to each database instance node.
    instances Sequence[GetDbSystemsDbSystemCollectionItemInstance]
    The list of instances, or nodes, in the database system.
    instances_details Sequence[GetDbSystemsDbSystemCollectionItemInstancesDetail]
    lifecycle_details str
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    management_policies Sequence[GetDbSystemsDbSystemCollectionItemManagementPolicy]
    PostgreSQL database system management policy.
    network_details Sequence[GetDbSystemsDbSystemCollectionItemNetworkDetail]
    Network details for the database system.
    patch_operations Sequence[GetDbSystemsDbSystemCollectionItemPatchOperation]
    shape str
    The name of the shape for the database instance. Example: VM.Standard.E4.Flex
    sources Sequence[GetDbSystemsDbSystemCollectionItemSource]
    The source used to restore the database system.
    state str
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    storage_details Sequence[GetDbSystemsDbSystemCollectionItemStorageDetail]
    Storage details of the database system.
    system_tags Mapping[str, str]
    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
    system_type str
    Type of the database system.
    time_created str
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    time_updated str
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    adminUsername String
    The database system administrator username.
    applyConfig String
    compartmentId String
    The ID of the compartment in which to list resources.
    configId String
    The OCID of the configuration associated with the database system.
    credentials List<Property Map>
    dbVersion String
    The major and minor versions of the database system software.
    definedTags Map<String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    Description of the database instance node.
    displayName String
    A filter to return only resources that match the entire display name given.
    freeformTags Map<String>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id String
    A unique identifier for the database system.
    instanceCount Number
    Count of instances, or nodes, in the database system.
    instanceMemorySizeInGbs Number
    The total amount of memory available to each database instance node, in gigabytes.
    instanceOcpuCount Number
    The total number of OCPUs available to each database instance node.
    instances List<Property Map>
    The list of instances, or nodes, in the database system.
    instancesDetails List<Property Map>
    lifecycleDetails String
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    managementPolicies List<Property Map>
    PostgreSQL database system management policy.
    networkDetails List<Property Map>
    Network details for the database system.
    patchOperations List<Property Map>
    shape String
    The name of the shape for the database instance. Example: VM.Standard.E4.Flex
    sources List<Property Map>
    The source used to restore the database system.
    state String
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    storageDetails List<Property Map>
    Storage details of the database system.
    systemTags Map<String>
    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}
    systemType String
    Type of the database system.
    timeCreated String
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    timeUpdated String
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

    GetDbSystemsDbSystemCollectionItemCredential

    GetDbSystemsDbSystemCollectionItemCredentialPasswordDetail

    Password string
    PasswordType string
    SecretId string
    SecretVersion string
    Password string
    PasswordType string
    SecretId string
    SecretVersion string
    password String
    passwordType String
    secretId String
    secretVersion String
    password string
    passwordType string
    secretId string
    secretVersion string
    password String
    passwordType String
    secretId String
    secretVersion String

    GetDbSystemsDbSystemCollectionItemInstance

    AvailabilityDomain string
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    Description string
    Description of the database instance node.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    Id string
    A unique identifier for the database system.
    LifecycleDetails string
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    State string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    TimeCreated string
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    TimeUpdated string
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    AvailabilityDomain string
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    Description string
    Description of the database instance node.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    Id string
    A unique identifier for the database system.
    LifecycleDetails string
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    State string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    TimeCreated string
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    TimeUpdated string
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    availabilityDomain String
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    description String
    Description of the database instance node.
    displayName String
    A filter to return only resources that match the entire display name given.
    id String
    A unique identifier for the database system.
    lifecycleDetails String
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    state String
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    timeCreated String
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    timeUpdated String
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    availabilityDomain string
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    description string
    Description of the database instance node.
    displayName string
    A filter to return only resources that match the entire display name given.
    id string
    A unique identifier for the database system.
    lifecycleDetails string
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    state string
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    timeCreated string
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    timeUpdated string
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    availability_domain str
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    description str
    Description of the database instance node.
    display_name str
    A filter to return only resources that match the entire display name given.
    id str
    A unique identifier for the database system.
    lifecycle_details str
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    state str
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    time_created str
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    time_updated str
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    availabilityDomain String
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    description String
    Description of the database instance node.
    displayName String
    A filter to return only resources that match the entire display name given.
    id String
    A unique identifier for the database system.
    lifecycleDetails String
    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
    state String
    A filter to return only resources if their lifecycleState matches the given lifecycleState.
    timeCreated String
    The date and time that the database system was created, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z
    timeUpdated String
    The date and time that the database system was updated, expressed in RFC 3339 timestamp format. Example: 2016-08-25T21:10:29.600Z

    GetDbSystemsDbSystemCollectionItemInstancesDetail

    Description string
    Description of the database instance node.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    PrivateIp string
    Description string
    Description of the database instance node.
    DisplayName string
    A filter to return only resources that match the entire display name given.
    PrivateIp string
    description String
    Description of the database instance node.
    displayName String
    A filter to return only resources that match the entire display name given.
    privateIp String
    description string
    Description of the database instance node.
    displayName string
    A filter to return only resources that match the entire display name given.
    privateIp string
    description str
    Description of the database instance node.
    display_name str
    A filter to return only resources that match the entire display name given.
    private_ip str
    description String
    Description of the database instance node.
    displayName String
    A filter to return only resources that match the entire display name given.
    privateIp String

    GetDbSystemsDbSystemCollectionItemManagementPolicy

    BackupPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy>
    PostgreSQL database system backup policy.
    MaintenanceWindowStart string
    The start of the maintenance window.
    BackupPolicies []GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy
    PostgreSQL database system backup policy.
    MaintenanceWindowStart string
    The start of the maintenance window.
    backupPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy>
    PostgreSQL database system backup policy.
    maintenanceWindowStart String
    The start of the maintenance window.
    backupPolicies GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy[]
    PostgreSQL database system backup policy.
    maintenanceWindowStart string
    The start of the maintenance window.
    backup_policies Sequence[GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy]
    PostgreSQL database system backup policy.
    maintenance_window_start str
    The start of the maintenance window.
    backupPolicies List<Property Map>
    PostgreSQL database system backup policy.
    maintenanceWindowStart String
    The start of the maintenance window.

    GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicy

    BackupStart string
    Hour of the day when the backup starts.
    CopyPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy>
    Backup copy details
    DaysOfTheMonths List<int>
    Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
    DaysOfTheWeeks List<string>
    The day of the week that the backup starts.
    Kind string
    The kind of backup policy.
    RetentionDays int
    How many days the data should be stored after the database system deletion.
    BackupStart string
    Hour of the day when the backup starts.
    CopyPolicies []GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy
    Backup copy details
    DaysOfTheMonths []int
    Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
    DaysOfTheWeeks []string
    The day of the week that the backup starts.
    Kind string
    The kind of backup policy.
    RetentionDays int
    How many days the data should be stored after the database system deletion.
    backupStart String
    Hour of the day when the backup starts.
    copyPolicies List<GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy>
    Backup copy details
    daysOfTheMonths List<Integer>
    Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
    daysOfTheWeeks List<String>
    The day of the week that the backup starts.
    kind String
    The kind of backup policy.
    retentionDays Integer
    How many days the data should be stored after the database system deletion.
    backupStart string
    Hour of the day when the backup starts.
    copyPolicies GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy[]
    Backup copy details
    daysOfTheMonths number[]
    Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
    daysOfTheWeeks string[]
    The day of the week that the backup starts.
    kind string
    The kind of backup policy.
    retentionDays number
    How many days the data should be stored after the database system deletion.
    backup_start str
    Hour of the day when the backup starts.
    copy_policies Sequence[GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy]
    Backup copy details
    days_of_the_months Sequence[int]
    Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
    days_of_the_weeks Sequence[str]
    The day of the week that the backup starts.
    kind str
    The kind of backup policy.
    retention_days int
    How many days the data should be stored after the database system deletion.
    backupStart String
    Hour of the day when the backup starts.
    copyPolicies List<Property Map>
    Backup copy details
    daysOfTheMonths List<Number>
    Day of the month when the backup should start. To ensure that the backup runs monthly, the latest day of the month that you can use to schedule a backup is the the 28th day.
    daysOfTheWeeks List<String>
    The day of the week that the backup starts.
    kind String
    The kind of backup policy.
    retentionDays Number
    How many days the data should be stored after the database system deletion.

    GetDbSystemsDbSystemCollectionItemManagementPolicyBackupPolicyCopyPolicy

    CompartmentId string
    The ID of the compartment in which to list resources.
    Regions List<string>
    List of region names of the remote region
    RetentionPeriod int
    Retention period in days of the backup copy.
    CompartmentId string
    The ID of the compartment in which to list resources.
    Regions []string
    List of region names of the remote region
    RetentionPeriod int
    Retention period in days of the backup copy.
    compartmentId String
    The ID of the compartment in which to list resources.
    regions List<String>
    List of region names of the remote region
    retentionPeriod Integer
    Retention period in days of the backup copy.
    compartmentId string
    The ID of the compartment in which to list resources.
    regions string[]
    List of region names of the remote region
    retentionPeriod number
    Retention period in days of the backup copy.
    compartment_id str
    The ID of the compartment in which to list resources.
    regions Sequence[str]
    List of region names of the remote region
    retention_period int
    Retention period in days of the backup copy.
    compartmentId String
    The ID of the compartment in which to list resources.
    regions List<String>
    List of region names of the remote region
    retentionPeriod Number
    Retention period in days of the backup copy.

    GetDbSystemsDbSystemCollectionItemNetworkDetail

    IsReaderEndpointEnabled bool
    Specifies if the reader endpoint is enabled on the dbSystem.
    NsgIds List<string>
    List of customer Network Security Group OCIDs associated with the database system.
    PrimaryDbEndpointPrivateIp string
    Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
    SubnetId string
    The OCID of the customer subnet associated with the database system.
    IsReaderEndpointEnabled bool
    Specifies if the reader endpoint is enabled on the dbSystem.
    NsgIds []string
    List of customer Network Security Group OCIDs associated with the database system.
    PrimaryDbEndpointPrivateIp string
    Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
    SubnetId string
    The OCID of the customer subnet associated with the database system.
    isReaderEndpointEnabled Boolean
    Specifies if the reader endpoint is enabled on the dbSystem.
    nsgIds List<String>
    List of customer Network Security Group OCIDs associated with the database system.
    primaryDbEndpointPrivateIp String
    Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
    subnetId String
    The OCID of the customer subnet associated with the database system.
    isReaderEndpointEnabled boolean
    Specifies if the reader endpoint is enabled on the dbSystem.
    nsgIds string[]
    List of customer Network Security Group OCIDs associated with the database system.
    primaryDbEndpointPrivateIp string
    Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
    subnetId string
    The OCID of the customer subnet associated with the database system.
    is_reader_endpoint_enabled bool
    Specifies if the reader endpoint is enabled on the dbSystem.
    nsg_ids Sequence[str]
    List of customer Network Security Group OCIDs associated with the database system.
    primary_db_endpoint_private_ip str
    Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
    subnet_id str
    The OCID of the customer subnet associated with the database system.
    isReaderEndpointEnabled Boolean
    Specifies if the reader endpoint is enabled on the dbSystem.
    nsgIds List<String>
    List of customer Network Security Group OCIDs associated with the database system.
    primaryDbEndpointPrivateIp String
    Private IP in customer subnet. The value is optional. If the IP is not provided, the IP will be chosen from the available IP addresses from the specified subnet.
    subnetId String
    The OCID of the customer subnet associated with the database system.

    GetDbSystemsDbSystemCollectionItemPatchOperation

    From string
    Operation string
    Position string
    SelectedItem string
    Selection string
    Value Dictionary<string, string>
    From string
    Operation string
    Position string
    SelectedItem string
    Selection string
    Value map[string]string
    from String
    operation String
    position String
    selectedItem String
    selection String
    value Map<String,String>
    from string
    operation string
    position string
    selectedItem string
    selection string
    value {[key: string]: string}
    from_ str
    operation str
    position str
    selected_item str
    selection str
    value Mapping[str, str]
    from String
    operation String
    position String
    selectedItem String
    selection String
    value Map<String>

    GetDbSystemsDbSystemCollectionItemSource

    BackupId string
    The OCID of the database system backup.
    IsHavingRestoreConfigOverrides bool
    Deprecated. Don't use.
    SourceType string
    The source descriminator.
    BackupId string
    The OCID of the database system backup.
    IsHavingRestoreConfigOverrides bool
    Deprecated. Don't use.
    SourceType string
    The source descriminator.
    backupId String
    The OCID of the database system backup.
    isHavingRestoreConfigOverrides Boolean
    Deprecated. Don't use.
    sourceType String
    The source descriminator.
    backupId string
    The OCID of the database system backup.
    isHavingRestoreConfigOverrides boolean
    Deprecated. Don't use.
    sourceType string
    The source descriminator.
    backup_id str
    The OCID of the database system backup.
    is_having_restore_config_overrides bool
    Deprecated. Don't use.
    source_type str
    The source descriminator.
    backupId String
    The OCID of the database system backup.
    isHavingRestoreConfigOverrides Boolean
    Deprecated. Don't use.
    sourceType String
    The source descriminator.

    GetDbSystemsDbSystemCollectionItemStorageDetail

    AvailabilityDomain string
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    Iops string
    Guaranteed input/output storage requests per second (IOPS) available to the database system.
    IsRegionallyDurable bool
    Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    SystemType string
    Type of the database system.
    AvailabilityDomain string
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    Iops string
    Guaranteed input/output storage requests per second (IOPS) available to the database system.
    IsRegionallyDurable bool
    Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    SystemType string
    Type of the database system.
    availabilityDomain String
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    iops String
    Guaranteed input/output storage requests per second (IOPS) available to the database system.
    isRegionallyDurable Boolean
    Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    systemType String
    Type of the database system.
    availabilityDomain string
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    iops string
    Guaranteed input/output storage requests per second (IOPS) available to the database system.
    isRegionallyDurable boolean
    Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    systemType string
    Type of the database system.
    availability_domain str
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    iops str
    Guaranteed input/output storage requests per second (IOPS) available to the database system.
    is_regionally_durable bool
    Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    system_type str
    Type of the database system.
    availabilityDomain String
    Specifies the availability domain of AD-local storage. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    iops String
    Guaranteed input/output storage requests per second (IOPS) available to the database system.
    isRegionallyDurable Boolean
    Specifies if the block volume used for the database system is regional or AD-local. If not specified, it will be set to false. If isRegionallyDurable is set to true, availabilityDomain should not be specified. If isRegionallyDurable is set to false, availabilityDomain must be specified.
    systemType String
    Type of the database system.

    GetDbSystemsFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci