From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgres account disabled . version 9.2 |
Date: | 2016-12-14 15:12:27 |
Message-ID: | 5851615B.6050106@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | xu jian | 2016-12-14 23:21:13 | blocking issue when create index concurrently |
Previous Message | Achilleas Mantzios | 2016-12-14 15:02:50 | Re: postgres account disabled . version 9.2 |