How do I create a postgresql user and database from a fresh install? - by josephturian 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. Read the article