DBeaver Can't access non-default database

Question

I'm using DBeaver 3.8.0 and trying to setup general connection to my local PostgreSQL database.

To view all the databases i have, I check the "Show non-default databases" checkbox. And when I try to access Schemas of one of my databases - I'm getting the error

org.jkiss.dbeaver.DBException: Can't access non-default database

Does this answer your question? [DBeaver can only see default PostgreSQL database in connection](https://stackoverflow.com/questions/54235029/dbeaver-can-only-see-default-postgresql-database-in-connection) — Omer, Nov 25 '22 at 11:44

score 89 · Accepted Answer · edited Dec 01 '16 at 00:14

89

Try to set your database active which you choose to open the schema:

edited Dec 01 '16 at 00:14

aschipfl

33,626
12
54
99

answered Nov 30 '16 at 23:31

ilo

906
7
3

13

I think it would be nice to have a configuration or setting where one can select "Set Active on click" OR "Set Active on double-click". This would be a nice to-have - similar to what happens in HeidiSQL – SourceVisor Jun 07 '17 at 15:51
1

@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight. – user3871 Jan 22 '18 at 23:23
2

@CodeBurner Newer versions have this [checkbox in the connection settings](https://github.com/dbeaver/dbeaver/issues/2892#issuecomment-362343541). – Martin May 11 '18 at 11:10

score 18 · Answer 2 · answered Jun 03 '20 at 08:29

18

Right-click on the Db Connection in the database navigator (right-click on PostgreSQL)
Click on edit connection

Select PostgreSQL tab
Select Show all databases

Click ok to save

Note: I am using DBeaver Enterprise 7.0.0

answered Jun 03 '20 at 08:29

Ravi Rajpurohit

502
6
15

moodboom · Answer 3 · 2018-12-30T23:35:57.690

For more recent versions of DBeaver, you can improve this confusing default behavior.

You need to change an "Editors" setting. There are several ways to get to the setting, an easy way is:

[Postgres - #name#] right-click > Properties

Under Editors, check the auto-sync box:

After that, any time you click on a database in the right-hand navigator, it will automatically be set as the active database, so things should just work.

These types of pain points are enough to drive you away from new tools, this one in particular. Hang in there!

DBeaver Can't access non-default database

3 Answers3