DBeaver can only see default PostgreSQL database in connection

Question

I use DBeaver v 5.2.5 on Windows and use it to connect to PostgreSQL databases.

To create a connection, I must specify the database and I have no mean to see other databases on the same server.

A colleague using DBeaver 5.3 on Mac has an option to see all databases, not just the default one.

Is there an equivalent setup on the windows version?

score 400 · Accepted Answer · answered Feb 18 '20 at 20:46

400

On the connection, right-click -> Edit connection -> Connection settings -> on the tabbed panel, select PostgreSQL, check the box Show all databases.

answered Feb 18 '20 at 20:46

Benny

5,218
5
24
28

96

how is this not a default? why yes, i would like to manage databases in an app made for managing databases. – northamerican Aug 20 '21 at 17:33
this causes a connection reset / lost connection. What setting do I need to fix on my cluster? without `show all databases` connection works fine. @northamerican `show all databases` can cause dropped connections aparently. – Stephan Aug 16 '22 at 13:37
3

@northamerican yep, totally don't get it. – Harlin Feb 02 '23 at 13:50
This should be the default behaviour. Thanks Benny. – Dark Aug 16 '23 at 14:44
How is this not set by default – Oluwaseye Aug 29 '23 at 18:07

Omer · Answer 2 · 2022-12-09T15:36:00.273

50

2023 Update...

Right-click on your connection
Click "Edit connection"
Left panel, click "Connection settings"
Select PostgreSQL tab Check the box "Show all databases"

edited Dec 09 '22 at 15:36

answered Nov 25 '22 at 11:35

Omer

8,194
13
74
92

7

Thank you, this saved me hours. I can't believe this isn't the default behavior, their UI can be incredibly confusing sometimes. – yazeedb Dec 16 '22 at 00:38
4

these are the same steps as the top answer... what's the 2023 update? – aacotroneo Jan 09 '23 at 14:02
1

Note: Same thing was happening to me, and it was already selected, I've deselected and selected again, clicked ok, and tables appeared. – siniradam Jan 10 '23 at 21:43
1

Thank you, had this same setting on the Oracle DB – Pasi Savolainen May 15 '23 at 12:17

score 2 · Answer 3 · answered Dec 13 '21 at 00:23

2

The same problem in DBeaver 21.3.1, Postgress 14.1 installed with brew on MacOS Catalina. I've solved it in the Connection settings:

On the connection, right-click -> Edit connection -> Connection settings -> then click button "Edit Driver Settings", check "Embedded" checkbox.

answered Dec 13 '21 at 00:23

Denis Anokhin

41
2

1

I had to close and re-open dbeaver to make this to work, but works now! – vindom Oct 20 '22 at 08:19

score 1 · Answer 4 · answered Feb 05 '19 at 17:38

1

Today I had to reinstall DBeaver on a new machine and this time, I let DBeaver download the postgresql drivers.

In this case, I can see the other databases so I can only assume that it was due to the jdbc drivers I loaded

answered Feb 05 '19 at 17:38

Eric Mamet

2,681
2
13
43

DBeaver can only see default PostgreSQL database in connection

4 Answers4

2023 Update...

Linked