Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46122=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cHBEO-00049l-QC
	for pgsql-admin@arkaria.postgresql.org; Wed, 14 Dec 2016 15:12:32 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46122=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cHBEO-00083w-D8
	for pgsql-admin@arkaria.postgresql.org; Wed, 14 Dec 2016 15:12:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <achill@matrix.gatewaynet.com>)
	id 1cHBEN-000827-AL
	for pgsql-admin@postgresql.org; Wed, 14 Dec 2016 15:12:31 +0000
Received: from host3.dynacom.ondsl.gr ([62.103.35.211]
 helo=smadev.internal.net)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <achill@matrix.gatewaynet.com>)
	id 1cHBEK-0004yW-IU
	for pgsql-admin@postgresql.org; Wed, 14 Dec 2016 15:12:30 +0000
Received: from smadev.internal.net (smadev [10.9.200.131])
	by smadev.internal.net (8.15.2/8.15.2) with ESMTP id uBEFCR4B027812
	for <pgsql-admin@postgresql.org>; Wed, 14 Dec 2016 17:12:27 +0200 (EET)
	(envelope-from achill@matrix.gatewaynet.com)
Subject: Re: postgres account disabled . version 9.2
To: pgsql-admin@postgresql.org
References: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg>
 <HE1P194MB004211A4818AE2493C7B5CA3CA9A0@HE1P194MB0042.EURP194.PROD.OUTLOOK.COM>
 <5851557E.6030201@matrix.gatewaynet.com>
 <HE1P194MB00425F209629980764CF1F05CA9A0@HE1P194MB0042.EURP194.PROD.OUTLOOK.COM>
 <58515F1A.6010408@matrix.gatewaynet.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <5851615B.6050106@matrix.gatewaynet.com>
Date: Wed, 14 Dec 2016 17:12:27 +0200
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: <58515F1A.6010408@matrix.gatewaynet.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin