Configuring DBeaver PRO

Suggest edits

Implementing DBeaver PRO with EDB Postgres Advanced Server and EDB Postgres Extended Server requires the following components:

  • A running EDB Postgres Advanced Server or EDB Postgres Extended Server instance.
  • DBeaver PRO application installed on a system where you will manage the running database.

EDB Postgres Advanced Server Configuration

  1. Launch DBeaver PRO on your system.
  2. Go to the Database drop down menu in the top left, and select New Database Connection. In the All tab, select EnterpriseDB and click Next.

EPASConfig

Note

You can also connect to your EDB database instance by selecting New Connection from JDBC URL from the Database menu. DBeaver PRO will automatically select EnterpriseDB in the Drivers field when the EDB JDBC URL is provided in the JDBC URL field. Click Proceed and continue to step 3.

JDBCURL

  1. Provide connection information for the user, password, host, port, and database for your EDB Postgres Advanced Server instance.

    ConnectionSettings

  2. Click Test Connection. The connection should be successful.

    SuccessfulConnection

  3. Click OK on this window and then click Finish on the Connection Settings window. The connection is then created and shown in the left-side tree.

    ConnectionOnLeftSide

EDB Postgres Extended Server Configuration

  1. Launch DBeaver PRO on your system.
  2. Go to the Database drop down menu in the top left, and select New Database Connection. In the All tab, select PostgreSQL and click Next.

    ExtendedConfiguration

Note

You can also connect to your PostgreSQL database instance by selecting New Connection from JDBC URL from the Database menu. DBeaver PRO will automatically select PostgreSQL in the Drivers field when the PostgreSQL JDBC URL is provided in the JDBC URL field. Click Proceed and continue to step 3.

NewConnectionExtended

  1. Provide connection information for the user, password, host, port, and database for your PostgreSQL instance.

    PostgreSQLInformation

  2. Click Test Connection. The connection should be successful.

    PostgresTestConnection

  3. Click OK on this window and then click Finish on the Connection Settings window. The connection is then created and shown in the left-side tree.

    PostgresConnectionSettings

Could this page be better? Report a problem or suggest an addition!