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