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 postgresql dark
Select a database type
select postgresql light
Select a database type

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

select driver dark
Select a PostgreSQL driver
select driver light
Select a PostgreSQL driver

Define the connection settings in the next window.

dbeaver settings dark
Connection settings
dbeaver settings light
Connection settings

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

dbeaver database navigator dark
DBeaver Database Navigator
dbeaver database navigator light
DBeaver Database Navigator

If you need to change authentication settings from pg_hba.conf for the DBeaver connection, use ADCM UI. Open CLUSTERS → ADPG cluster → Services → ADPG → Configuration tab and edit the PG_HBA field. To save changes and update pg_hba.conf, click the Save button.

edit pghba
Edit the PG_HBA section

Execute the Reconfigure & Reload 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