diff options
author | Julien Dessaux | 2021-03-12 18:12:41 +0100 |
---|---|---|
committer | Julien Dessaux | 2021-03-12 18:13:45 +0100 |
commit | ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7 (patch) | |
tree | cd93f66cd66f8ca6efe91882d8a46ca6b09bdc72 /content/blog/miscellaneous/my-postgresql-role-cannot-login.md | |
parent | Improved home speech (diff) | |
download | www-ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7.tar.gz www-ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7.tar.bz2 www-ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7.zip |
Some more articles reformatting
Diffstat (limited to 'content/blog/miscellaneous/my-postgresql-role-cannot-login.md')
-rw-r--r-- | content/blog/miscellaneous/my-postgresql-role-cannot-login.md | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/content/blog/miscellaneous/my-postgresql-role-cannot-login.md b/content/blog/miscellaneous/my-postgresql-role-cannot-login.md index 2b958bf..d85f3bf 100644 --- a/content/blog/miscellaneous/my-postgresql-role-cannot-login.md +++ b/content/blog/miscellaneous/my-postgresql-role-cannot-login.md @@ -1,12 +1,18 @@ --- title: "Cannot login role into postgresql" -linkTitle: "Cannot login role into postgresql" date: 2015-11-24 -description: > - Cannot login role into postgresql +description: How to fix a "Cannot login role" error on postgresql +tags: + - PostgreSQL --- +## The problem + +Login is a permission on postgresql, that sometimes is not obvious it can cause issues. + +## The solution + +Simply log in as postgres or another administrator account and run : {{< highlight sh >}} ALTER ROLE "user" LOGIN; {{< /highlight >}} - |