3.4. Database Connections #
3.4.1. Creating a Database Connection #
In the navigation panel, go to Projects → Connections.
In the top-right corner of the page, click Create connection.
Enter parameters of the new database connection (parameters marked with an asterisk are required):
Name.
Database type.
Possible values:
Postgres Pro/PostgreSQL
Oracle
Specify the following parameters:
Server.
Port.
Database.
Username: The name of the user to access the database.
Password: The user password to access the database.
To show the password in clear text or hide it, click
or 
. Maximum connections.
Connection parameters.
Enter the key word and its value.
For more information, refer to the official Postgres Pro documentation on connection parameter key words.
You can add multiple connection parameters by clicking + Add parameter.
Click Create.
3.4.2. Viewing Database Connections #
In the navigation panel, go to Projects → Connections.
The table of database connections with the following columns will be displayed:
Name/ID.
Type.
Possible values:
PostgreSQL
Oracle Database
Creation date: The date and time when the database connection was created.
Host/Port: The host and port of the database connection.
Health: The database connection state.
Possible values:
Healthy
Unreachable
Actions.
For more information about available actions, refer to other instructions in this section.
3.4.3. Checking a Database Connection #
In the navigation panel, go to Projects → Connections.
Click
next to the database connection. The current connection state will be displayed.
3.4.4. Editing a Database Connection #
In the navigation panel, go to Projects → Connections.
Click
next to the database connection. Edit database connection parameters. Enter your password before saving the parameters.
Click Save.
3.4.5. Deleting a Database Connection #
Important
Deleted database connections cannot be restored.
To delete a database connection:
In the navigation panel, go to Projects → Connections.
Click
next to the database connection. Click Delete.