Postgres Pro
Downloads
Home   >   mailing lists

Lost superuser login grant - Mailing list pgsql-admin

From Davide Toller
Subject Lost superuser login grant
Date
Msg-id CAJcb3p5j1Dxz0AXVYRPB+HDZAm3OoxnSCNghDSWmO4GLTgo5qg@mail.gmail.com
Whole thread Raw
Responses Re: Lost superuser login grant  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
List pgsql-admin
Tree view
Hello to all,
I made a mistake by revoking the grant login to my superuser "postgres".

Now, when I try to access my database I get the following error:

psql: FATAL:  role "postgres" is not permitted to log in

I'm working with Postgres 9.3 on Red Hat 6.
There is a way to give back the login grant to user "postgres"?

I tried to edit the pg_hba.conf, but I was not able to login anyway.


Thanks & Regards,
Davide

pgsql-admin by date:

Previous
From: Glyn Astill
Date:
Subject: Re: pb_basebackup process not working
Next
From: Julien Rouhaud
Date:
Subject: Re: Lost superuser login grant