Cannot login to postgres with newly created users
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to initialize policy plugin
I then checked the user list when using the default postgres user to see if there were in fact any other users. It returned the following:
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
newuser | Superuser, Create role, Create DB | {}
newuser2 | Superuser, Create role, Create DB | {}
newuser3 | Superuser, Create role, Create DB, Replication | {}
postgres | Superuser, Create role, Create DB, Replication | {}
So I know that they are there. Why is it failing?
My end goal is to use this local db as my database for my deployed server. They are both installed on the same vm and I just want the REST calls from my server to interact with the local database, which I assume should be no problem, if I could ever connect to it.
postgresql postgresql-9.5 users centos-7
asked Sep 10 '18 at 19:33
BrandonBrandon
94
bumped to the homepage by Community♦ 3 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to initialize policy plugin
I then checked the user list when using the default postgres user to see if there were in fact any other users. It returned the following:
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
newuser | Superuser, Create role, Create DB | {}
newuser2 | Superuser, Create role, Create DB | {}
newuser3 | Superuser, Create role, Create DB, Replication | {}
postgres | Superuser, Create role, Create DB, Replication | {}
So I know that they are there. Why is it failing?
My end goal is to use this local db as my database for my deployed server. They are both installed on the same vm and I just want the REST calls from my server to interact with the local database, which I assume should be no problem, if I could ever connect to it.
postgresql postgresql-9.5 users centos-7
asked Sep 10 '18 at 19:33
BrandonBrandon
94
bumped to the homepage by Community♦ 3 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to initialize policy plugin
I then checked the user list when using the default postgres user to see if there were in fact any other users. It returned the following:
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
newuser | Superuser, Create role, Create DB | {}
newuser2 | Superuser, Create role, Create DB | {}
newuser3 | Superuser, Create role, Create DB, Replication | {}
postgres | Superuser, Create role, Create DB, Replication | {}
So I know that they are there. Why is it failing?
My end goal is to use this local db as my database for my deployed server. They are both installed on the same vm and I just want the REST calls from my server to interact with the local database, which I assume should be no problem, if I could ever connect to it.
postgresql postgresql-9.5 users centos-7
asked Sep 10 '18 at 19:33
BrandonBrandon
94
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to initialize policy plugin
I then checked the user list when using the default postgres user to see if there were in fact any other users. It returned the following:
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
newuser | Superuser, Create role, Create DB | {}
newuser2 | Superuser, Create role, Create DB | {}
newuser3 | Superuser, Create role, Create DB, Replication | {}
postgres | Superuser, Create role, Create DB, Replication | {}
So I know that they are there. Why is it failing?
My end goal is to use this local db as my database for my deployed server. They are both installed on the same vm and I just want the REST calls from my server to interact with the local database, which I assume should be no problem, if I could ever connect to it.
postgresql postgresql-9.5 users centos-7
postgresql postgresql-9.5 users centos-7
asked Sep 10 '18 at 19:33
BrandonBrandon
94
asked Sep 10 '18 at 19:33
BrandonBrandon
94
asked Sep 10 '18 at 19:33
BrandonBrandon
94
asked Sep 10 '18 at 19:33
BrandonBrandon
94
asked Sep 10 '18 at 19:33
BrandonBrandon
94
94
bumped to the homepage by Community♦ 3 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 3 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
2 things were required to solve this problem
service postgresql reload and I had to give postgres a password.
Unaware how to connect externally without a password but I wouldn't want to anyways so not concern about it.
I also failed to have a new user function properly, only the default one worked. But it does work now.
answered Sep 10 '18 at 20:47
BrandonBrandon
94
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f217207%2fcannot-login-to-postgres-with-newly-created-users%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
2 things were required to solve this problem
service postgresql reload and I had to give postgres a password.
Unaware how to connect externally without a password but I wouldn't want to anyways so not concern about it.
I also failed to have a new user function properly, only the default one worked. But it does work now.
answered Sep 10 '18 at 20:47
BrandonBrandon
94
add a comment |
2 things were required to solve this problem
service postgresql reload and I had to give postgres a password.
Unaware how to connect externally without a password but I wouldn't want to anyways so not concern about it.
I also failed to have a new user function properly, only the default one worked. But it does work now.
answered Sep 10 '18 at 20:47
BrandonBrandon
94
add a comment |
2 things were required to solve this problem
service postgresql reload and I had to give postgres a password.
Unaware how to connect externally without a password but I wouldn't want to anyways so not concern about it.
I also failed to have a new user function properly, only the default one worked. But it does work now.
answered Sep 10 '18 at 20:47
BrandonBrandon
94
2 things were required to solve this problem
service postgresql reload and I had to give postgres a password.
Unaware how to connect externally without a password but I wouldn't want to anyways so not concern about it.
I also failed to have a new user function properly, only the default one worked. But it does work now.
answered Sep 10 '18 at 20:47
BrandonBrandon
94
answered Sep 10 '18 at 20:47
BrandonBrandon
94
answered Sep 10 '18 at 20:47
BrandonBrandon
94
answered Sep 10 '18 at 20:47
BrandonBrandon
94
94
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fdba.stackexchange.com%2fquestions%2f217207%2fcannot-login-to-postgres-with-newly-created-users%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
