From ed8e2b9e9ed67097d4fdc7913df1c6cd2d96d3f7 Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Fri, 12 Mar 2021 18:12:41 +0100 Subject: Some more articles reformatting --- .../blog/miscellaneous/my-postgresql-role-cannot-login.md | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'content/blog/miscellaneous/my-postgresql-role-cannot-login.md') 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 >}} - -- cgit v1.2.3