Postgresql – newbie problems


1) Requires password all the time when starting pgAdmin 4 (which is irrelevant for localhost)

Solution:
go to C:\Program Files\PostgreSQL\15\pgAdmin 4\web\
make a copy of the file config.py
call it config_local.py
Change MASTER_PASSWORD_REQUIRED to False

2) By setting the bin folder to PATH, you can call from the terminal
psql
but get error: psql: error: connection to server at “localhost” (::1), port 5432 failed: FATAL: password authentication failed for user “vasya”

Solution:
run from regular user psql -U postgres 

 


This entry was posted in Postgress (en). Bookmark the permalink.

Leave a Reply

🇬🇧 Attention! Comments with URLs/email are not allowed.
🇷🇺 Комментарии со ссылками/email удаляются автоматически.