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

2023-03-15 Thread Tom Lane
Raivo Rebane 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_hb

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

2023-03-15 Thread Adrian Klaver
On 3/15/23 09:02, Raivo Rebane wrote: HI I wanted to install PostGIS Bundle so that it builds a sample spatial database, but got error - createdb: error: connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "postgres" Then I altered rol

How to behive if I remove password from postgres role

2023-03-15 Thread Raivo Rebane
HI I wanted to install PostGIS Bundle so that it builds a sample spatial database, but got error - createdb: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres" Then I altered role of postgres so, that password = NULL. Now