pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres account disabled . version 9.2
4+ messages / 2 participants
[nested] [flat]
* postgres account disabled . version 9.2
@ 2016-12-14 14:16 koffi BADOH <koff10@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: koffi BADOH @ 2016-12-14 14:16 UTC (permalink / raw)
To: pgsql-admin
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"
help please
koff
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres account disabled . version 9.2
@ 2016-12-14 14:21 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: koffi BADOH <koff10@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Achilleas Mantzios @ 2016-12-14 14:21 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres account disabled . version 9.2
@ 2016-12-14 15:02 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 4+ messages in thread
From: Achilleas Mantzios @ 2016-12-14 15:02 UTC (permalink / raw)
To: koffi BADOH <koff10@hotmail.com>; 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres account disabled . version 9.2
@ 2016-12-14 15:12 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 4+ messages in thread
From: Achilleas Mantzios @ 2016-12-14 15:12 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-12-14 15:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-12-14 14:16 postgres account disabled . version 9.2 koffi BADOH <koff10@hotmail.com>
2016-12-14 14:21 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2016-12-14 15:02 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2016-12-14 15:12 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox