PostgreSQL

Default: The system automatically concatenates data source connection character strings based on configured data.
Professional: You need to specify the data source connection string manually.

The PostgreSQL connector is used to connect to a PostgreSQL database by establishing and maintaining the connection between applications and the database, and managing data transmission.

PostgreSQL is a full-featured, open-source object-relational database.
The default PostgreSQL port number is 5432. The administrator can change the port number as required.

Creating a PostgreSQL Connection

Log in to the new ROMA Connect console.
In the navigation pane on the left, choose Connector. On the page displayed, click New Connection.
Select the PostgreSQL connector.

In the dialog box displayed, configure the connector and click OK.

Parameter	Description
Name	Enter the connector instance name.
Region	Select a region.
Project	Select a project.
Instance	Select an instance for subsequent connectivity verification.
Connection and Security	Select the connection mode for the database. Default: The system automatically concatenates data source connection character strings based on configured data. Professional: You need to specify the data source connection string manually.
IP Address	Required when Connection and Security is set to Default. Enter the IP address of the database.
Port	Required when Connection and Security is set to Default. Enter the port number to which the database is connected.
Database Name	Required when Connection and Security is set to Default. Enter the name of the database to be connected.
Connection String	Required when Connection and Security is set to Professional. Enter the JDBC connection string of the PostgreSQL database, for example, jdbc:postgresql://{hostname}:{port}/{dbname}.
Username	Enter the username used to connect to the database.
Password	Enter the password used to connect to the database.
Description	Enter the description of the connector to identify it.