current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

When I run CREATE USER username WITH PASSWORD 'test' in sudo -u postgres psql and run \du only postgres user appears... I'm not prompted anything when running commands like ALTER USER and I know USER ALTERED should appear, or something similar.

share|improve this question
    
what do you see in the log? set log_statements to all and see, if the SQL actually makes it to the server. could it be some hidden password prompt or so? –  Hans-Jürgen Schönig Aug 11 at 10:49

1 Answer 1

up vote 0 down vote accepted

Did you end the command with a semicolon?

CREATE USER username WITH PASSWORD 'test';
share|improve this answer
    
omg... I can't thank you enough –  user2510745 Aug 11 at 17:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.