How to connect DBeaver or CloudBeaver to PostgreSQL on a separate VM in Azure

Table of contents

• Connect your VM with CloudBeaver to PostgreSQL
  • Configure a peering for your networks
  • Run CloudBeaver on the Linux VM and connect it to PostgreSQL
    • Step 1. Running CloudBeaver
    • Step 2. Configure your network to access CloudBeaver
    • Step 3. Configure CloudBeaver and connect to PostgreSQL
  • Connect DBeaver from Win VM to PostgreSQL

Connect your VM with CloudBeaver to PostgreSQL

Configure a peering for your networks

1. Log in to your account in Microsoft Azure and go to Virtual networks.

2. Select the network that you created during the VM startup process.

3. Select Overview -> Capabilities -> Peerings and click Add peering.

4. The Add peering window will be opened.

• In the Peering link name field add the name for the new peering.

• In the Virtual network field select the network where your database is located (SQL-vpc in this case).

5. Click Create. The peering is configured.

Run CloudBeaver on the Linux VM and connect it to PostgreSQL

Step 1. Running CloudBeaver

1. Connect to your Linux VM via SSH:

ssh -i ~/.ssh/<your_pub_key> <username>@<your_ip>

2. Check that your Linux VM has access to your SQL DB private IP.

• Copy the private IP address of your database in Virtual machines -> Your SQL DB -> Properties -> Networking.

• Ping this IP in the terminal:

If everything was done correctly in the previous steps, you will get the result as in the screenshot above. All that remains is to connect our CloudBeaver server to your database.

3. Install Docker if it is not installed. Check this documentation for details.

4. Run CloudBeaver with this command:

docker run -d --name cloudbeaver-ee --rm -ti -p 8080:8978 -v /var/cloudbeaver/workspace:/opt/cloudbeaver/workspace dbeaver/cloudbeaver-ee:latest

You can learn more about CloudBeaver deployment in our documentation.

Step 2. Configure your network to access CloudBeaver

You need to make small changes to the network configuration so that you can access CloudBeaver UI.

1. Go to Virtual machines -> Networking -> Inbound port rules -> Add inbound port rule

2. Add access to port 8080. For security reasons, we recommend specifying your IP or the IP of your proxy in the resource to avoid third-party access.

3. Open in browser http://<your_vm_ip>:8080

That's all done! You are in the CloudBeaver interface.

Step 3. Configure CloudBeaver and connect to PostgreSQL

1. Enter your license key and configure your server.

2. Go to Connection Templates, click Add, and type your database name (PostgreSQL for example).

3. In the Host field enter the IP address of your database you received earlier and indicate the authorization data for your database.

4. Click TEST to check that your configuration works.

5. Perfect! Now click CREATE in the top right. Connection to your database is added to CloudBeaver.

Connect DBeaver from Win VM to PostgreSQL

1. Connect to your Windows VM by using RDP.

2. Check that your Linux VM has access to your SQL DB private IP.

• Copy the private IP address of your database in Virtual machines -> Your SQL DB -> Properties -> Networking.

• Ping this IP in the terminal:

If everything was done correctly in the previous steps, you will get the result as in the screenshot above. All that remains is to connect our DBeaver to your database.

3. Add your license when starting the application.

4. Create a new connection and choose your database (for example, PostgreSQL).

5. In the Host field, specify the Private IP address of your database and fill in other fields.

Perfect! Your connection is ready.