Обсуждение: Lost superuser login grant
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
On 20/10/2016 14:25, Davide Toller wrote: > 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 think the only way is to stop postgres, and launch it in single user mode: postgres --single -D /path/to/pgdata Then you should be able to grant login privilege to your superuser. -- Julien Rouhaud http://dalibo.com - http://dalibo.org