Burning-Chai/CreateUserforPostgres.md

Created May 28, 2016 07:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Burning-Chai/2af4fcd9fab6abe64bece77a037729fd.js"></script>
Save Burning-Chai/2af4fcd9fab6abe64bece77a037729fd to your computer and use it in GitHub Desktop.

Raw

    $ sudo su - postgres -c 'psql'

postgres=# create database <database name>;
postgres=# create user <user name> password '<password>';
postgres=# alter database <database name> owner to <user name>;