![]() ![]() What we’ve done is simply give the created user the ability to create a database. Let’s proceed to assign the user a role, we do that with the command: ALTER ROLE username CREATEDB With the user created, you should be able to log into Postgres now with your credentials.Īt this time, the only action we can perform is to log in, because no role has been assigned to the created user. ![]() Remember to add the semi-colon at the end of the command, Postgres can act weird at times when the semi-colon isn’t there. We can then proceed to create a new user with the command CREATE ROLE username WITH LOGIN PASSWORD 'quoted password' UPDATE Found an easier fix that might work for you, check it out here: ![]() $ postgres -D /usr/local/var/postgres $ rm -rf /usr/local/var/postgres
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |