create superuser in postgres

Please login or create account to add a snippet.

Follow @TagMyCode

Language: Text

Posted by: Marina Lariutina

Added: Apr 15, 2022 6:07 PM

Tags: no tags

заходим в базу
/Applications/Postgres.app/Contents/Versions/14/bin/psql -p5432 "td"
CREATE USER marina WITH password '123'; создаем юзера
CREATE ROLE
td=# GRANT ALL ON DATABASE td TO marina; наделяем правами
GRANT
td=#
/Applications/Postgres.app/Contents/Versions/14/bin/psql -p5432 -h localhost td marina
проверям