Re: How to behive if I remove password from postgres role

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