I just installed postgresql onto an ubuntu box.

How can I create user foo with password bar and database baz, so that foo owns baz? foo is not a unix user.

link|improve this question

43% accept rate
feedback

1 Answer

CREATE ROLE foo WITH ENCRYPTED PASSWORD 'bar';
CREATE DATABASE baz OWNER foo;

Don't forget to modify pg_hba.conf to allow foo to connect with the md5 method.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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