Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cHB6t-0003mI-In for pgsql-admin@arkaria.postgresql.org; Wed, 14 Dec 2016 15:04:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cHB6t-0004DJ-42 for pgsql-admin@arkaria.postgresql.org; Wed, 14 Dec 2016 15:04:47 +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 ) id 1cHB5D-0002GM-OM for pgsql-admin@postgresql.org; Wed, 14 Dec 2016 15:03:03 +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 ) id 1cHB58-0004hU-9C for pgsql-admin@postgresql.org; Wed, 14 Dec 2016 15:03:01 +0000 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id uBEF2oNZ027580; Wed, 14 Dec 2016 17:02:50 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: postgres account disabled . version 9.2 To: koffi BADOH , pgsql-admin@postgresql.org References: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg> <5851557E.6030201@matrix.gatewaynet.com> From: Achilleas Mantzios Message-ID: <58515F1A.6010408@matrix.gatewaynet.com> Date: Wed, 14 Dec 2016 17:02:50 +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: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 > > 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