Re: postgres account disabled . version 9.2

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