/** * GoldenGate API * Use the Oracle Cloud Infrastructure GoldenGate APIs to perform data replication operations. * OpenAPI spec version: 20200407 * * * NOTE: This class is auto generated by OracleSDKGenerator. * Do not edit the class manually. * * Copyright (c) 2020, 2026, Oracle and/or its affiliates. All rights reserved. * This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl or Apache License 2.0 as shown at http://www.apache.org/licenses/LICENSE-2.0. You may choose either license. */ import * as model from "../model"; /** * Represents the metadata of a PostgreSQL Database Connection. * */ export interface PostgresqlConnection extends model.Connection { /** * The PostgreSQL technology type. */ "technologyType": PostgresqlConnection.TechnologyType; /** * The name of the database. * */ "databaseName": string; /** * The name or address of a host. * */ "host": string; /** * The port of an endpoint usually specified for a connection. * Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues. */ "port": number; /** * The username Oracle GoldenGate uses to connect the associated system of the given technology. * This username must already exist and be available by the system/application to be connected to * and must conform to the case sensitivty requirments defined in it. * */ "username": string; /** * An array of name-value pair attribute entries. * Used as additional parameters in connection string. * */ "additionalAttributes"?: Array; /** * Security protocol for PostgreSQL. */ "securityProtocol": PostgresqlConnection.SecurityProtocol; /** * SSL mode for PostgreSQL. */ "sslMode"?: PostgresqlConnection.SslMode; /** * This property is not available when creating connections. For existing deprecated connections having this value set, the value cannot be updated; set it to empty. *

For deprecated connections created with this field in the past, either the private IP had to be specified in the connectionString or host field, or the host name had to be resolvable in the target VCN. * */ "privateIp"?: string; /** * The [OCID](https://docs.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the database system being referenced. * */ "dbSystemId"?: string; /** * The [OCID](https://docs.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Secret where the password is stored. * The password Oracle GoldenGate uses to connect the associated system of the given technology. * It must conform to the specific security requirements including length, case sensitivity, and so on. * If secretId is used plaintext field must not be provided. * Note: When provided, 'password' field must not be provided. * */ "passwordSecretId"?: string; /** * The [OCID](https://docs.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Secret that stores the private key of the PostgreSQL server. The supported file formats are .pem and .crt. * Note: When provided, 'sslKey' field must not be provided. * */ "sslKeySecretId"?: string; /** * The base64 encoded certificate of the trusted certificate authorities (Trusted CA) for PostgreSQL. * The supported file formats are .pem and .crt. * It is not included in GET responses if the {@code view=COMPACT} query parameter is specified. * */ "sslCa"?: string; /** * The base64 encoded list of certificates revoked by the trusted certificate authorities (Trusted CA). * It is not included in GET responses if the {@code view=COMPACT} query parameter is specified. * */ "sslCrl"?: string; /** * The base64 encoded certificate of the PostgreSQL server. The supported file formats are .pem and .crt. * It is not included in GET responses if the {@code view=COMPACT} query parameter is specified. * */ "sslCert"?: string; "connectionType": string; } export declare namespace PostgresqlConnection { enum TechnologyType { OciPostgresql = "OCI_POSTGRESQL", PostgresqlServer = "POSTGRESQL_SERVER", AmazonAuroraPostgresql = "AMAZON_AURORA_POSTGRESQL", AmazonRdsPostgresql = "AMAZON_RDS_POSTGRESQL", AzurePostgresql = "AZURE_POSTGRESQL", AzureCosmosDbForPostgresql = "AZURE_COSMOS_DB_FOR_POSTGRESQL", EdbPostgresAdvancedServer = "EDB_POSTGRES_ADVANCED_SERVER", GoogleCloudSqlPostgresql = "GOOGLE_CLOUD_SQL_POSTGRESQL", GoogleAlloyDbForPostgresql = "GOOGLE_ALLOY_DB_FOR_POSTGRESQL", YugabyteDb = "YUGABYTE_DB", /** * This value is used if a service returns a value for this enum that is not recognized by this * version of the SDK. */ UnknownValue = "UNKNOWN_VALUE" } enum SecurityProtocol { Plain = "PLAIN", Tls = "TLS", Mtls = "MTLS", /** * This value is used if a service returns a value for this enum that is not recognized by this * version of the SDK. */ UnknownValue = "UNKNOWN_VALUE" } enum SslMode { Prefer = "PREFER", Require = "REQUIRE", VerifyCa = "VERIFY_CA", VerifyFull = "VERIFY_FULL", /** * This value is used if a service returns a value for this enum that is not recognized by this * version of the SDK. */ UnknownValue = "UNKNOWN_VALUE" } function getJsonObj(obj: PostgresqlConnection, isParentJsonObj?: boolean): object; const connectionType = "POSTGRESQL"; function getDeserializedJsonObj(obj: PostgresqlConnection, isParentJsonObj?: boolean): object; }