How to configure Postgres connection for this use case? #88

Open
opened 2026-03-04 09:09:05 -05:00 by deekerman · 0 comments
Owner

Originally created by @toddpfaff on GitHub (Nov 16, 2020).

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). 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.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/cloudbeaver#88
No description provided.