Raivo Rebane <raivore55@xxxxxxxxx> 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
