Postgres Pro
Downloads
Home   >   mailing lists

Re: How to behive if I remove password from postgres role - Mailing list pgsql-general

From Tom Lane
Subject Re: How to behive if I remove password from postgres role
Date
Msg-id 3339367.1678896743@sss.pgh.pa.us
Whole thread Raw
In response to How to behive if I remove password from postgres role  (Raivo Rebane <raivore55@gmail.com>)
List pgsql-general
Tree view 
Raivo Rebane <raivore55@gmail.com> writes:
> Then I altered role of postgres so, that password = NULL.
> Now I am in situation that I can't run any postgres command.
> What I must to do ?

Stop the server, start it in single-user mode (postgres --single),
issue an ALTER USER command to undo the damage.

Or modify pg_hba.conf to let you in without a password.  Local
peer auth, for example, is perfectly secure.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to behive if I remove password from postgres role
Next
From: Tom Lane
Date:
Subject: Re: Table scan on 15.2