1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Psql
  5. getDbSystemConnectionDetail
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

oci.Psql.getDbSystemConnectionDetail

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 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: testDbSystem.id,
});
Copy
import pulumi
import pulumi_oci as oci

test_db_system_connection_detail = oci.Psql.get_db_system_connection_detail(db_system_id=test_db_system["id"])
Copy
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.GetDbSystemConnectionDetail(ctx, &psql.GetDbSystemConnectionDetailArgs{
			DbSystemId: testDbSystem.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
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 = testDbSystem.Id,
    });

});
Copy
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(testDbSystem.id())
            .build());

    }
}
Copy
variables:
  testDbSystemConnectionDetail:
    fn::invoke:
      function: oci:Psql:getDbSystemConnectionDetail
      arguments:
        dbSystemId: ${testDbSystem.id}
Copy

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>
Copy
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]
Copy
func GetDbSystemConnectionDetail(ctx *Context, args *GetDbSystemConnectionDetailArgs, opts ...InvokeOption) (*GetDbSystemConnectionDetailResult, error)
func GetDbSystemConnectionDetailOutput(ctx *Context, args *GetDbSystemConnectionDetailOutputArgs, opts ...InvokeOption) GetDbSystemConnectionDetailResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetDbSystemConnectionDetailResult> getDbSystemConnectionDetail(GetDbSystemConnectionDetailArgs args, InvokeOptions options)
public static Output<GetDbSystemConnectionDetailResult> getDbSystemConnectionDetail(GetDbSystemConnectionDetailArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:Psql/getDbSystemConnectionDetail:getDbSystemConnectionDetail
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

DbSystemId This property is required. string
A unique identifier for the database system.
DbSystemId This property is required. string
A unique identifier for the database system.
dbSystemId This property is required. String
A unique identifier for the database system.
dbSystemId This property is required. string
A unique identifier for the database system.
db_system_id This property is required. str
A unique identifier for the database system.
dbSystemId This property is required. 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.
ReaderEndpoints List<GetDbSystemConnectionDetailReaderEndpoint>
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.
ReaderEndpoints []GetDbSystemConnectionDetailReaderEndpoint
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.
readerEndpoints List<GetDbSystemConnectionDetailReaderEndpoint>
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.
readerEndpoints GetDbSystemConnectionDetailReaderEndpoint[]
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.
reader_endpoints Sequence[psql.GetDbSystemConnectionDetailReaderEndpoint]
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.
readerEndpoints List<Property Map>
Information about the database instance node endpoint.

Supporting Types

GetDbSystemConnectionDetailInstanceEndpoint

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

GetDbSystemConnectionDetailInstanceEndpointEndpoint

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

GetDbSystemConnectionDetailPrimaryDbEndpoint

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

GetDbSystemConnectionDetailReaderEndpoint

Fqdn This property is required. string
The FQDN of the endpoint.
IpAddress This property is required. string
The IP address of the endpoint.
Port This property is required. int
The port address of the endpoint.
Fqdn This property is required. string
The FQDN of the endpoint.
IpAddress This property is required. string
The IP address of the endpoint.
Port This property is required. int
The port address of the endpoint.
fqdn This property is required. String
The FQDN of the endpoint.
ipAddress This property is required. String
The IP address of the endpoint.
port This property is required. Integer
The port address of the endpoint.
fqdn This property is required. string
The FQDN of the endpoint.
ipAddress This property is required. string
The IP address of the endpoint.
port This property is required. number
The port address of the endpoint.
fqdn This property is required. str
The FQDN of the endpoint.
ip_address This property is required. str
The IP address of the endpoint.
port This property is required. int
The port address of the endpoint.
fqdn This property is required. String
The FQDN of the endpoint.
ipAddress This property is required. String
The IP address of the endpoint.
port This property is required. 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.
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi