PostgreSQL

Configure PostgreSQL connection

Accessing the PostgreSQL Connector

• Navigate to the Connectors Page from the main menu.

• Select Add Storage and choose PostgreSQL from the list of available connectors.

Connection Settings

• Connection name. Enter a unique name for this connection

• Host. Specify the hostname or IP address of your PostgreSQL server.

• Port. Enter the port number your PostgreSQL server is listening on. The default port for PostgreSQL is 5432.

• Username. Enter the username that will be used to connect to your PostgreSQL database.

• Password. Enter the password associated with the provided username.

• Database. Provide the name of the database you wish to connect to within your PostgreSQL server.

• Schema (optional). Enter the schema name here if you need to set a specific schema as default. You can leave this field blank or select another schema in the Source node in the Flow Designer.

Test and Save

• Test connection. Click this button to verify that the connection settings are correct. If successful, you will see a confirmation message. If there are issues, you will receive an error message detailing what needs to be corrected.

• Save and Test. This button allows you to save your settings and immediately test the connection. If the connection test is successful, the connector will be saved and ready for use.