Re: postgres account disabled . version 9.2

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

 



On 14/12/2016 17:02, Achilleas Mantzios wrote:
On 14/12/2016 16:28, koffi BADOH wrote:
PostgreSql is already started.

I cannot connect    as postgres account

stop it via sending a SIGTERM, SIGINT, or SIGQUIT signal

kill -TERM <pgsql_pid>


Then do :

postgres --single -D <your data cluster> <your db name>

backend> ALTER ROLE postgres WITH LOGIN;

or any command that would revert the effects previous command that you gave.




Le 14/12/2016 à 15:21, Achilleas Mantzios a écrit :
On 14/12/2016 16:16, koffi BADOH wrote:
Hi all,

I'm in a big trouble.

I'm running postgreSQL 9.2.
For migration reason  I disabled  all postgres user account login .
Unfortunatly That's mean  the  postgres admin  account cannot also
connect.
Now I'm trying to enable all account , Then I got error


" psql fatal role postgres is not permitted to log in"
start it standalone

      help please
koff









--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt



--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[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