PostgreSQL: Create New User And Database

• Tweet
• 

        Create a new user in PostgreSQL, then add a new database as that owner.  

$ sudo -u postgres createuser -D -A -P mynewuser
$ sudo -u postgres createdb -O mynewuser mydatabase 

Reference: 
<a href="http://www.ubuntugeek.com/howto-setup-database-server-with-postgresql-and-pgadmin3.html">How to Setup a Database Server with PostgreSQL</a>    

Tags:
• PostgreSQL
• ubuntu