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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
