DBeaver Can't access non-default database
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
postgresql dbeaver
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
add a comment |
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
postgresql dbeaver
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
add a comment |
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
postgresql dbeaver
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
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
postgresql dbeaver
postgresql dbeaver
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
asked Nov 25 '16 at 5:37
JekisJekis
2,38112531
2,38112531
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Try to set your database active which you choose to open the schema:
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
answered Nov 30 '16 at 23:31
iloilo
80653
12
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
– CodeBurner
Jun 7 '17 at 15:51
1
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
2
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
add a comment |
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!
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f40798369%2fdbeaver-cant-access-non-default-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try to set your database active which you choose to open the schema:
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
answered Nov 30 '16 at 23:31
iloilo
80653
12
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
– CodeBurner
Jun 7 '17 at 15:51
1
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
2
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
add a comment |
Try to set your database active which you choose to open the schema:
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
answered Nov 30 '16 at 23:31
iloilo
80653
12
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
– CodeBurner
Jun 7 '17 at 15:51
1
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
2
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
add a comment |
Try to set your database active which you choose to open the schema:
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
answered Nov 30 '16 at 23:31
iloilo
80653
Try to set your database active which you choose to open the schema:
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
answered Nov 30 '16 at 23:31
iloilo
80653
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
edited Dec 1 '16 at 0:14
aschipfl
18.5k82856
18.5k82856
answered Nov 30 '16 at 23:31
iloilo
80653
answered Nov 30 '16 at 23:31
iloilo
80653
answered Nov 30 '16 at 23:31
iloilo
80653
80653
12
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
– CodeBurner
Jun 7 '17 at 15:51
1
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
2
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
add a comment |
12
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
– CodeBurner
Jun 7 '17 at 15:51
1
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
2
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
12
12
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
– CodeBurner
Jun 7 '17 at 15:51
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
– CodeBurner
Jun 7 '17 at 15:51
1
1
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
@CodeBurner yeah. This is obnoxious. It's quite an obvious oversight.
– Growler
Jan 22 '18 at 23:23
2
2
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
@CodeBurner Newer versions have this checkbox in the connection settings.
– Martin
May 11 '18 at 11:10
add a comment |
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!
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
add a comment |
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!
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
add a comment |
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!
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
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!
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
edited Dec 30 '18 at 23:35
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
answered Dec 30 '18 at 22:41
moodboommoodboom
2,89912739
2,89912739
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f40798369%2fdbeaver-cant-access-non-default-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
