Lost superuser login grant

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux