| From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | koffi BADOH <koff10(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgres account disabled . version 9.2 |
| Date: | 2016-12-14 15:02:50 |
| Message-ID: | 58515F1A.6010408@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2016-12-14 15:12:27 | Re: postgres account disabled . version 9.2 |
| Previous Message | Achilleas Mantzios | 2016-12-14 14:21:50 | Re: postgres account disabled . version 9.2 |