Re: [ADMIN] postgres account disabled . version 9.2 - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: [ADMIN] postgres account disabled . version 9.2
Date
Msg-id 58515F1A.6010408@matrix.gatewaynet.com
Whole thread Raw
In response to very slow postgresql startup  (zz_11@mail.bg)
Responses Re: [ADMIN] postgres account disabled . version 9.2  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
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>

>
> 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



pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: [ADMIN] postgres account disabled . version 9.2
Next
From: Achilleas Mantzios
Date:
Subject: Re: [ADMIN] postgres account disabled . version 9.2