aboutsummaryrefslogtreecommitdiff
path: root/content/blog/miscellaneous/my-postgresql-role-cannot-login.md
diff options
context:
space:
mode:
authorJulien Dessaux2021-03-12 18:12:41 +0100
committerJulien Dessaux2021-03-12 18:13:45 +0100
commited8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7 (patch)
treecd93f66cd66f8ca6efe91882d8a46ca6b09bdc72 /content/blog/miscellaneous/my-postgresql-role-cannot-login.md
parentImproved home speech (diff)
downloadwww-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.md14
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 >}}
-