Answer the question
In order to leave comments, you need to log in
Why is the user not being created?
I installed postgres on linux mint, logged in as a superuser and try to create a user who has a login / password, and who cannot create a database, can log in, cannot create superusers:
[email protected] ~ $ sudo -i -u postgres
[sudo] password for kalinin:
[email protected] ~ $ man createuser
[email protected] ~ $ createuser -W qwerty -U qwerty -h localhost -S -R -l -D
Password:
createuser: could not connect to database postgres: FATAL: password authentication failed for user "qwerty"
FATAL: password authentication failed for user "qwerty"
[email protected] ~ $ sudo -i -u postgres
Answer the question
In order to leave comments, you need to log in
The key -U
specifies the login not of the newly created user, but of the user who creates it, under which the utility connects to the DBMS.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question