Class CreatePostgresqlConnectionDetails

The information about a new PostgreSQL Connection.

Inheritance

object

CreateConnectionDetails

CreatePostgresqlConnectionDetails

Inherited Members

CreateConnectionDetails.DisplayName

CreateConnectionDetails.Description

CreateConnectionDetails.CompartmentId

CreateConnectionDetails.FreeformTags

CreateConnectionDetails.DefinedTags

CreateConnectionDetails.Locks

CreateConnectionDetails.VaultId

CreateConnectionDetails.KeyId

CreateConnectionDetails.NsgIds

CreateConnectionDetails.SubnetId

CreateConnectionDetails.RoutingMethod

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.GoldengateService.Models

Assembly: OCI.DotNetSDK.Goldengate.dll

Syntax

public class CreatePostgresqlConnectionDetails : CreateConnectionDetails

Properties

AdditionalAttributes

Declaration

[JsonProperty(PropertyName = "additionalAttributes")]
public List<NameValuePair> AdditionalAttributes { get; set; }

Property Value

Type	Description
List<NameValuePair>	An array of name-value pair attribute entries. Used as additional parameters in connection string.

DatabaseName

Declaration

[Required(ErrorMessage = "DatabaseName is required.")]
[JsonProperty(PropertyName = "databaseName")]
public string DatabaseName { get; set; }

Property Value

Type	Description
string	The name of the database.

Remarks

Required

DbSystemId

Declaration

[JsonProperty(PropertyName = "dbSystemId")]
public string DbSystemId { get; set; }

Property Value

Type	Description
string	The OCID of the database system being referenced.

Host

Declaration

[JsonProperty(PropertyName = "host")]
public string Host { get; set; }

Property Value

Type	Description
string	The name or address of a host.

Password

Declaration

[Required(ErrorMessage = "Password is required.")]
[JsonProperty(PropertyName = "password")]
public string Password { get; set; }

Property Value

Type	Description
string	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.

Remarks

Required

Port

Declaration

[JsonProperty(PropertyName = "port")]
public int? Port { get; set; }

Property Value

Type	Description
int?	The port of an endpoint usually specified for a connection.

PrivateIp

Declaration

[JsonProperty(PropertyName = "privateIp")]
public string PrivateIp { get; set; }

Property Value

Type

Description

string

Deprecated: this field will be removed in future versions. Either specify the private IP in the connectionString or host field, or make sure the host name is resolvable in the target VCN. The private IP address of the connection's endpoint in the customer's VCN, typically a database endpoint or a big data endpoint (e.g. Kafka bootstrap server). In case the privateIp is provided, the subnetId must also be provided. In case the privateIp (and the subnetId) is not provided it is assumed the datasource is publicly accessible. In case the connection is accessible only privately, the lack of privateIp will result in not being able to access the connection.

SecurityProtocol

Declaration

[Required(ErrorMessage = "SecurityProtocol is required.")]
[JsonProperty(PropertyName = "securityProtocol")]
[JsonConverter(typeof(StringEnumConverter))]
public PostgresqlConnection.SecurityProtocolEnum? SecurityProtocol { get; set; }

Property Value

Type	Description
PostgresqlConnection.SecurityProtocolEnum?	Security protocol for PostgreSQL.

Remarks

Required

SslCa

Declaration

[JsonProperty(PropertyName = "sslCa")]
public string SslCa { get; set; }

Property Value

Type	Description
string	The base64 encoded certificate of the trusted certificate authorities (Trusted CA) for PostgreSQL. The supported file formats are .pem and .crt.

SslCert

Declaration

[JsonProperty(PropertyName = "sslCert")]
public string SslCert { get; set; }

Property Value

Type	Description
string	The base64 encoded certificate of the PostgreSQL server. The supported file formats are .pem and .crt.

SslCrl

Declaration

[JsonProperty(PropertyName = "sslCrl")]
public string SslCrl { get; set; }

Property Value

Type	Description
string	The base64 encoded list of certificates revoked by the trusted certificate authorities (Trusted CA).

SslKey

Declaration

[JsonProperty(PropertyName = "sslKey")]
public string SslKey { get; set; }

Property Value

Type	Description
string	The base64 encoded private key of the PostgreSQL server. The supported file formats are .pem and .crt.

SslMode

Declaration

[JsonProperty(PropertyName = "sslMode")]
[JsonConverter(typeof(StringEnumConverter))]
public PostgresqlConnection.SslModeEnum? SslMode { get; set; }

Property Value

Type	Description
PostgresqlConnection.SslModeEnum?	SSL modes for PostgreSQL.

TechnologyType

Declaration

[Required(ErrorMessage = "TechnologyType is required.")]
[JsonProperty(PropertyName = "technologyType")]
[JsonConverter(typeof(StringEnumConverter))]
public PostgresqlConnection.TechnologyTypeEnum? TechnologyType { get; set; }

Property Value

Type	Description
PostgresqlConnection.TechnologyTypeEnum?	The PostgreSQL technology type.

Remarks

Required

Username

Declaration

[Required(ErrorMessage = "Username is required.")]
[JsonProperty(PropertyName = "username")]
public string Username { get; set; }

Property Value

Type	Description
string	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.

Remarks

Required