Raivo Rebane <raivor...@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
