Use DBeaver to connect to ADPG

Eugenia Kuzina

The third-party client tool DBeaver supports different databases and can be used to connect to a PostgreSQL server.

For information on how to install DBeaver, refer to Installation.

To connect to an ADPG host, launch DBeaver and select PostgreSQL in the Connect to a database window.

Select a database type
Select a database type
Select a database type
Select a database type

If you connect to a PostgreSQL server for the first time, select a driver.

Select a PostgreSQL driver
Select a PostgreSQL driver
Select a PostgreSQL driver
Select a PostgreSQL driver

Define the connection settings in the next window.

Connection settings
Connection settings
Connection settings
Connection settings

After the connection is established, DBeaver displays the specified database on the Database Navigator tab.

DBeaver Database Navigator
DBeaver Database Navigator
DBeaver Database Navigator
DBeaver Database Navigator

If you need to change authentication settings from pg_hba.conf for the DBeaver connection, use ADCM UI. Open the Clusters page, select an ADPG cluster, and switch to the Services tab. Select the ADPG service, click the PG_HBA option on the Primary configuration tab, and edit the value.

Edit the PG_HBA section
Edit the PG_HBA section

Enter a record of the pg_hba.conf file in the pop-up window and click Apply.

Add a PG_HBA record
Add a PG_HBA record

To save changes, click Save.

Save changes
Save changes

Execute the Reconfigure & Restart action to apply changes.

For more information on DBeaver, refer to official documentation.

Found a mistake? Seleсt text and press Ctrl+Enter to report it