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.