Deploying openGauss Locally on Windows Using Docker and Connecting via DBeaver

Begin by installing Docker Desktop for Windows from the official Docker website. After installation, verify it by runing:

docker -v

A version string confirms successful setup.

Next, pull a compatible openGauss Docker image. Version 3.0.0 is recommended for stability:

docker pull enmotech/opengauss:3.0.0

Avoid latest if possible, as newer versions (e.g., 5.0.0) may introduce compatibility issues on Windows.

Launch a container from the image, mapping host port 5433 to the container’s default PostgreSQL port 5432:

docker run -d -p 5433:5432 --name local-opengauss enmotech/opengauss:3.0.0

Once running, access the container’s shell:

docker exec -it local-opengauss /bin/bash

Switch to the omm user and start the openGauss interactive client:

su - omm
gsql

Successful entry into the gsql prompt indicates the database is operational. Create a test database if needed:

CREATE DATABASE demo;

For GUI access, install DBeaver Community Edition. Download the openGauss JDBC driver (version 3.0.0) from the official openGauss software repository.

In DBeaver, navigate to Database > Driver Manager, create a new driver configuration, and point it to the downloaded JDBC JAR file. Set the clas name to org.postgresql.Driver and use the following connection URL template:

jdbc:postgresql://localhost:5433/demo

Use default credentials (omm as username, password set during container initialization—often Enmo@123 for this image). Test the connection; success confirms end-to-end setup.

Tags: openGauss docker DBeaver Windows Database Deployment

Posted on Sun, 10 May 2026 15:04:08 +0000 by herbally