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