[GH-ISSUE #219] How to configure Postgres connection for this use case? #63

New issue

Closed

opened 2026-03-07 20:44:20 +03:00 by kerem · 2 comments

kerem commented

2026-03-07 20:44:20 +03:00

Owner

Originally created by @toddpfaff on GitHub (Nov 16, 2020).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/219

I am beginning to test CloudBeaver as a tool to provide a consistent web interface to users of our various database services, including MySQL, MariaDB, Postgres,and MS-SQL.

My current goal is to allow anonymous connections to CloudBeaver and, from there, users would create a new connection to their database using one of the templates we provide. They would provide their database username and password, establish an authenticated connection to the DB server, and be presented with a list of database for which their authenticated credentials have access.

This is exactly how our MySQL / MariaDB database users are accustomed to working with phpMyAdmin.

This is working as expected for a MySQL connection, using the MySQL driver provided with CloudBeaver.

Unfortunately this is not working similarly for Postgres. In the Postgres case, regardless of the Postgres user credentials provided, a connection is being established but only the "postgres" database is visible.

Can anyone tell me if it's possible to have a CloudBeaver Postgres connection behave similarly in this respect to a CloudBeaver MySQL connection, and to phpMyAdmin?

Thanks.

Originally created by @toddpfaff on GitHub (Nov 16, 2020). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/219 I am beginning to test CloudBeaver as a tool to provide a consistent web interface to users of our various database services, including MySQL, MariaDB, Postgres,and MS-SQL. My current goal is to allow anonymous connections to CloudBeaver and, from there, users would create a new connection to their database using one of the templates we provide. They would provide their database username and password, establish an authenticated connection to the DB server, and be presented with a list of database for which their authenticated credentials have access. This is exactly how our MySQL / MariaDB database users are accustomed to working with phpMyAdmin. This is working as expected for a MySQL connection, using the MySQL driver provided with CloudBeaver. Unfortunately this is not working similarly for Postgres. In the Postgres case, regardless of the Postgres user credentials provided, a connection is being established but only the "postgres" database is visible. Can anyone tell me if it's possible to have a CloudBeaver Postgres connection behave similarly in this respect to a CloudBeaver MySQL connection, and to phpMyAdmin? Thanks.

kerem

2026-03-07 20:44:20 +03:00

closed this issue
added the
x:postgresql
label

kerem commented

2026-03-07 20:44:21 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Jan 19, 2021):

We are going to implement this option in the future. While you can use 2 workarounds:

create a separate connection for every database
set parameter @dbeaver-show-non-default-db@": "true" in JSON file for PostgreSQLhttps://github.com/dbeaver/cloudbeaver/wiki/Configuring-server-datasources

@kseniiaguzeeva commented on GitHub (Jan 19, 2021): We are going to implement this option in the future. While you can use 2 workarounds: - create a separate connection for every database - set parameter @dbeaver-show-non-default-db@": "true" in JSON file for PostgreSQLhttps://github.com/dbeaver/cloudbeaver/wiki/Configuring-server-datasources

kerem commented

2026-03-07 20:44:22 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Feb 11, 2021):

PostgreSQL specific settings were added to the latest CE version 20.0.3. You can set Show all databases parameter now.

@kseniiaguzeeva commented on GitHub (Feb 11, 2021): PostgreSQL specific settings were added to the latest CE version 20.0.3. You can set **Show all databases** parameter now. ![chrome_R5ZXmvtITf](https://user-images.githubusercontent.com/51405061/107628104-37e83080-6c71-11eb-85f4-9f78d14833cd.png)

kerem referenced this issue

2026-03-07 21:03:54 +03:00

[PR #63] [MERGED] Cb 43 refresh data #1417