1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Psql
  5. getDbSystemConnectionDetail
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

oci.Psql.getDbSystemConnectionDetail

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

    This data source provides details about a specific Db System Connection Detail resource in Oracle Cloud Infrastructure Psql service.

    Gets the database system connection details.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testDbSystemConnectionDetail = oci.Psql.getDbSystemConnectionDetail({
        dbSystemId: oci_psql_db_system.test_db_system.id,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_db_system_connection_detail = oci.Psql.get_db_system_connection_detail(db_system_id=oci_psql_db_system["test_db_system"]["id"])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/Psql"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := Psql.GetDbSystemConnectionDetail(ctx, &psql.GetDbSystemConnectionDetailArgs{
    			DbSystemId: oci_psql_db_system.Test_db_system.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 testDbSystemConnectionDetail = Oci.Psql.GetDbSystemConnectionDetail.Invoke(new()
        {
            DbSystemId = oci_psql_db_system.Test_db_system.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.GetDbSystemConnectionDetailArgs;
    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 testDbSystemConnectionDetail = PsqlFunctions.getDbSystemConnectionDetail(GetDbSystemConnectionDetailArgs.builder()
                .dbSystemId(oci_psql_db_system.test_db_system().id())
                .build());
    
        }
    }
    
    variables:
      testDbSystemConnectionDetail:
        fn::invoke:
          Function: oci:Psql:getDbSystemConnectionDetail
          Arguments:
            dbSystemId: ${oci_psql_db_system.test_db_system.id}
    

    Using getDbSystemConnectionDetail

    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 getDbSystemConnectionDetail(args: GetDbSystemConnectionDetailArgs, opts?: InvokeOptions): Promise<GetDbSystemConnectionDetailResult>
    function getDbSystemConnectionDetailOutput(args: GetDbSystemConnectionDetailOutputArgs, opts?: InvokeOptions): Output<GetDbSystemConnectionDetailResult>
    def get_db_system_connection_detail(db_system_id: Optional[str] = None,
                                        opts: Optional[InvokeOptions] = None) -> GetDbSystemConnectionDetailResult
    def get_db_system_connection_detail_output(db_system_id: Optional[pulumi.Input[str]] = None,
                                        opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemConnectionDetailResult]
    func GetDbSystemConnectionDetail(ctx *Context, args *GetDbSystemConnectionDetailArgs, opts ...InvokeOption) (*GetDbSystemConnectionDetailResult, error)
    func GetDbSystemConnectionDetailOutput(ctx *Context, args *GetDbSystemConnectionDetailOutputArgs, opts ...InvokeOption) GetDbSystemConnectionDetailResultOutput

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

    public static class GetDbSystemConnectionDetail 
    {
        public static Task<GetDbSystemConnectionDetailResult> InvokeAsync(GetDbSystemConnectionDetailArgs args, InvokeOptions? opts = null)
        public static Output<GetDbSystemConnectionDetailResult> Invoke(GetDbSystemConnectionDetailInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDbSystemConnectionDetailResult> getDbSystemConnectionDetail(GetDbSystemConnectionDetailArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:Psql/getDbSystemConnectionDetail:getDbSystemConnectionDetail
      arguments:
        # arguments dictionary

    The following arguments are supported:

    DbSystemId string
    A unique identifier for the database system.
    DbSystemId string
    A unique identifier for the database system.
    dbSystemId String
    A unique identifier for the database system.
    dbSystemId string
    A unique identifier for the database system.
    db_system_id str
    A unique identifier for the database system.
    dbSystemId String
    A unique identifier for the database system.

    getDbSystemConnectionDetail Result

    The following output properties are available:

    CaCertificate string
    The CA certificate to be used by the PosgreSQL client to connect to the database. The CA certificate is used to authenticate the server identity. It is issued by PostgreSQL Service Private CA.
    DbSystemId string
    Id string
    The provider-assigned unique ID for this managed resource.
    InstanceEndpoints List<GetDbSystemConnectionDetailInstanceEndpoint>
    The list of database instance node endpoints in the database system.
    PrimaryDbEndpoints List<GetDbSystemConnectionDetailPrimaryDbEndpoint>
    Information about the database instance node endpoint.
    CaCertificate string
    The CA certificate to be used by the PosgreSQL client to connect to the database. The CA certificate is used to authenticate the server identity. It is issued by PostgreSQL Service Private CA.
    DbSystemId string
    Id string
    The provider-assigned unique ID for this managed resource.
    InstanceEndpoints []GetDbSystemConnectionDetailInstanceEndpoint
    The list of database instance node endpoints in the database system.
    PrimaryDbEndpoints []GetDbSystemConnectionDetailPrimaryDbEndpoint
    Information about the database instance node endpoint.
    caCertificate String
    The CA certificate to be used by the PosgreSQL client to connect to the database. The CA certificate is used to authenticate the server identity. It is issued by PostgreSQL Service Private CA.
    dbSystemId String
    id String
    The provider-assigned unique ID for this managed resource.
    instanceEndpoints List<GetDbSystemConnectionDetailInstanceEndpoint>
    The list of database instance node endpoints in the database system.
    primaryDbEndpoints List<GetDbSystemConnectionDetailPrimaryDbEndpoint>
    Information about the database instance node endpoint.
    caCertificate string
    The CA certificate to be used by the PosgreSQL client to connect to the database. The CA certificate is used to authenticate the server identity. It is issued by PostgreSQL Service Private CA.
    dbSystemId string
    id string
    The provider-assigned unique ID for this managed resource.
    instanceEndpoints GetDbSystemConnectionDetailInstanceEndpoint[]
    The list of database instance node endpoints in the database system.
    primaryDbEndpoints GetDbSystemConnectionDetailPrimaryDbEndpoint[]
    Information about the database instance node endpoint.
    ca_certificate str
    The CA certificate to be used by the PosgreSQL client to connect to the database. The CA certificate is used to authenticate the server identity. It is issued by PostgreSQL Service Private CA.
    db_system_id str
    id str
    The provider-assigned unique ID for this managed resource.
    instance_endpoints Sequence[psql.GetDbSystemConnectionDetailInstanceEndpoint]
    The list of database instance node endpoints in the database system.
    primary_db_endpoints Sequence[psql.GetDbSystemConnectionDetailPrimaryDbEndpoint]
    Information about the database instance node endpoint.
    caCertificate String
    The CA certificate to be used by the PosgreSQL client to connect to the database. The CA certificate is used to authenticate the server identity. It is issued by PostgreSQL Service Private CA.
    dbSystemId String
    id String
    The provider-assigned unique ID for this managed resource.
    instanceEndpoints List<Property Map>
    The list of database instance node endpoints in the database system.
    primaryDbEndpoints List<Property Map>
    Information about the database instance node endpoint.

    Supporting Types

    GetDbSystemConnectionDetailInstanceEndpoint

    DbInstanceId string
    Unique identifier of the database instance node.
    Endpoints List<GetDbSystemConnectionDetailInstanceEndpointEndpoint>
    Information about the database instance node endpoint.
    DbInstanceId string
    Unique identifier of the database instance node.
    Endpoints []GetDbSystemConnectionDetailInstanceEndpointEndpoint
    Information about the database instance node endpoint.
    dbInstanceId String
    Unique identifier of the database instance node.
    endpoints List<GetDbSystemConnectionDetailInstanceEndpointEndpoint>
    Information about the database instance node endpoint.
    dbInstanceId string
    Unique identifier of the database instance node.
    endpoints GetDbSystemConnectionDetailInstanceEndpointEndpoint[]
    Information about the database instance node endpoint.
    db_instance_id str
    Unique identifier of the database instance node.
    endpoints Sequence[psql.GetDbSystemConnectionDetailInstanceEndpointEndpoint]
    Information about the database instance node endpoint.
    dbInstanceId String
    Unique identifier of the database instance node.
    endpoints List<Property Map>
    Information about the database instance node endpoint.

    GetDbSystemConnectionDetailInstanceEndpointEndpoint

    Fqdn string
    The FQDN of the endpoint.
    IpAddress string
    The IP address of the endpoint.
    Port int
    The port address of the endpoint.
    Fqdn string
    The FQDN of the endpoint.
    IpAddress string
    The IP address of the endpoint.
    Port int
    The port address of the endpoint.
    fqdn String
    The FQDN of the endpoint.
    ipAddress String
    The IP address of the endpoint.
    port Integer
    The port address of the endpoint.
    fqdn string
    The FQDN of the endpoint.
    ipAddress string
    The IP address of the endpoint.
    port number
    The port address of the endpoint.
    fqdn str
    The FQDN of the endpoint.
    ip_address str
    The IP address of the endpoint.
    port int
    The port address of the endpoint.
    fqdn String
    The FQDN of the endpoint.
    ipAddress String
    The IP address of the endpoint.
    port Number
    The port address of the endpoint.

    GetDbSystemConnectionDetailPrimaryDbEndpoint

    Fqdn string
    The FQDN of the endpoint.
    IpAddress string
    The IP address of the endpoint.
    Port int
    The port address of the endpoint.
    Fqdn string
    The FQDN of the endpoint.
    IpAddress string
    The IP address of the endpoint.
    Port int
    The port address of the endpoint.
    fqdn String
    The FQDN of the endpoint.
    ipAddress String
    The IP address of the endpoint.
    port Integer
    The port address of the endpoint.
    fqdn string
    The FQDN of the endpoint.
    ipAddress string
    The IP address of the endpoint.
    port number
    The port address of the endpoint.
    fqdn str
    The FQDN of the endpoint.
    ip_address str
    The IP address of the endpoint.
    port int
    The port address of the endpoint.
    fqdn String
    The FQDN of the endpoint.
    ipAddress String
    The IP address of the endpoint.
    port Number
    The port address of the endpoint.

    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 v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi