1. Packages
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. Psql
  6. getDbSystemReplicas
Viewing docs for Oracle Cloud Infrastructure v4.16.0
published on Wednesday, Jun 17, 2026 by Pulumi
oci logo
Viewing docs for Oracle Cloud Infrastructure v4.16.0
published on Wednesday, Jun 17, 2026 by Pulumi

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

    Returns a list of replica database systems.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testDbSystemReplicas = oci.psql.getDbSystemReplicas({
        dbSystemId: testDbSystem.id,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_db_system_replicas = oci.psql.get_db_system_replicas(db_system_id=test_db_system["id"])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v4/go/oci/psql"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := psql.GetDbSystemReplicas(ctx, &psql.GetDbSystemReplicasArgs{
    			DbSystemId: testDbSystem.Id,
    		}, 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 testDbSystemReplicas = Oci.Psql.GetDbSystemReplicas.Invoke(new()
        {
            DbSystemId = testDbSystem.Id,
        });
    
    });
    
    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.GetDbSystemReplicasArgs;
    import java.util.ArrayList;
    import java.util.Arrays;
    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 testDbSystemReplicas = PsqlFunctions.getDbSystemReplicas(GetDbSystemReplicasArgs.builder()
                .dbSystemId(testDbSystem.id())
                .build());
    
        }
    }
    
    variables:
      testDbSystemReplicas:
        fn::invoke:
          function: oci:Psql:getDbSystemReplicas
          arguments:
            dbSystemId: ${testDbSystem.id}
    
    pulumi {
      required_providers {
        oci = {
          source = "pulumi/oci"
        }
      }
    }
    
    data "oci_psql_getdbsystemreplicas" "testDbSystemReplicas" {
      db_system_id = testDbSystem.id
    }
    

    Using getDbSystemReplicas

    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 getDbSystemReplicas(args: GetDbSystemReplicasArgs, opts?: InvokeOptions): Promise<GetDbSystemReplicasResult>
    function getDbSystemReplicasOutput(args: GetDbSystemReplicasOutputArgs, opts?: InvokeOptions): Output<GetDbSystemReplicasResult>
    def get_db_system_replicas(db_system_id: Optional[str] = None,
                               filters: Optional[Sequence[GetDbSystemReplicasFilter]] = None,
                               opts: Optional[InvokeOptions] = None) -> GetDbSystemReplicasResult
    def get_db_system_replicas_output(db_system_id: pulumi.Input[Optional[str]] = None,
                               filters: pulumi.Input[Optional[Sequence[pulumi.Input[GetDbSystemReplicasFilterArgs]]]] = None,
                               opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemReplicasResult]
    func GetDbSystemReplicas(ctx *Context, args *GetDbSystemReplicasArgs, opts ...InvokeOption) (*GetDbSystemReplicasResult, error)
    func GetDbSystemReplicasOutput(ctx *Context, args *GetDbSystemReplicasOutputArgs, opts ...InvokeOption) GetDbSystemReplicasResultOutput

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

    public static class GetDbSystemReplicas 
    {
        public static Task<GetDbSystemReplicasResult> InvokeAsync(GetDbSystemReplicasArgs args, InvokeOptions? opts = null)
        public static Output<GetDbSystemReplicasResult> Invoke(GetDbSystemReplicasInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDbSystemReplicasResult> getDbSystemReplicas(GetDbSystemReplicasArgs args, InvokeOptions options)
    public static Output<GetDbSystemReplicasResult> getDbSystemReplicas(GetDbSystemReplicasArgs args, InvokeOptions options)
    
    fn::invoke:
      function: oci:Psql/getDbSystemReplicas:getDbSystemReplicas
      arguments:
        # arguments dictionary
    data "oci_psql_getdbsystemreplicas" "name" {
        # arguments
    }

    The following arguments are supported:

    DbSystemId string
    A unique identifier for the database system.
    Filters List<GetDbSystemReplicasFilter>
    DbSystemId string
    A unique identifier for the database system.
    Filters []GetDbSystemReplicasFilter
    db_system_id string
    A unique identifier for the database system.
    filters list(object)
    dbSystemId String
    A unique identifier for the database system.
    filters List<GetDbSystemReplicasFilter>
    dbSystemId string
    A unique identifier for the database system.
    filters GetDbSystemReplicasFilter[]
    db_system_id str
    A unique identifier for the database system.
    filters Sequence[GetDbSystemReplicasFilter]
    dbSystemId String
    A unique identifier for the database system.
    filters List<Property Map>

    getDbSystemReplicas Result

    The following output properties are available:

    DbSystemId string
    DbSystemReplicaCollections List<GetDbSystemReplicasDbSystemReplicaCollection>
    The list of db_system_replica_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    Filters List<GetDbSystemReplicasFilter>
    DbSystemId string
    DbSystemReplicaCollections []GetDbSystemReplicasDbSystemReplicaCollection
    The list of db_system_replica_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    Filters []GetDbSystemReplicasFilter
    db_system_id string
    db_system_replica_collections list(object)
    The list of db_system_replica_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    filters list(object)
    dbSystemId String
    dbSystemReplicaCollections List<GetDbSystemReplicasDbSystemReplicaCollection>
    The list of db_system_replica_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    filters List<GetDbSystemReplicasFilter>
    dbSystemId string
    dbSystemReplicaCollections GetDbSystemReplicasDbSystemReplicaCollection[]
    The list of db_system_replica_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    filters GetDbSystemReplicasFilter[]
    db_system_id str
    db_system_replica_collections Sequence[GetDbSystemReplicasDbSystemReplicaCollection]
    The list of db_system_replica_collection.
    id str
    The provider-assigned unique ID for this managed resource.
    filters Sequence[GetDbSystemReplicasFilter]
    dbSystemId String
    dbSystemReplicaCollections List<Property Map>
    The list of db_system_replica_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    filters List<Property Map>

    Supporting Types

    GetDbSystemReplicasDbSystemReplicaCollection

    items list(object)
    List of replica database systems.
    items List<Property Map>
    List of replica database systems.

    GetDbSystemReplicasDbSystemReplicaCollectionItem

    Id string
    A unique identifier for the replica database system.
    Region string
    Region name of the replica database system region. Example: us-phoenix-1
    Id string
    A unique identifier for the replica database system.
    Region string
    Region name of the replica database system region. Example: us-phoenix-1
    id string
    A unique identifier for the replica database system.
    region string
    Region name of the replica database system region. Example: us-phoenix-1
    id String
    A unique identifier for the replica database system.
    region String
    Region name of the replica database system region. Example: us-phoenix-1
    id string
    A unique identifier for the replica database system.
    region string
    Region name of the replica database system region. Example: us-phoenix-1
    id str
    A unique identifier for the replica database system.
    region str
    Region name of the replica database system region. Example: us-phoenix-1
    id String
    A unique identifier for the replica database system.
    region String
    Region name of the replica database system region. Example: us-phoenix-1

    GetDbSystemReplicasFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name string
    values list(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
    Viewing docs for Oracle Cloud Infrastructure v4.16.0
    published on Wednesday, Jun 17, 2026 by Pulumi

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial