postgresql DBeaver 无法访问非默认数据库

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/40798369/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-21 02:27:18  来源:igfitidea点击:

DBeaver Can't access non-default database

postgresqldbeaver

提问by Jekis

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

我正在使用 DBeaver 3.8.0 并尝试设置与本地 PostgreSQL 数据库的常规连接。

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

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

Connection settingsAccess error

连接设置访问错误

回答by ilo

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

尝试将您选择打开架构的数据库设置为活动状态:

picture

图片

回答by moodboom

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

对于 DBeaver 的更新版本,您可以改进这种令人困惑的默认行为。

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

[Postgres - #name#] 右键单击​​ > 属性

Under Editors, check the auto-sync box:

在编辑器下,选中自动同步框:

enter image description here

在此处输入图片说明

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!

这些类型的痛点足以让您远离新工具,尤其是这个。挂在那里!