Last active
April 25, 2019 15:32
-
-
Save sanjaykrishnan/1d08a4aeb6d1393e5d61023cbafeb503 to your computer and use it in GitHub Desktop.
Create New DB and user in postgres
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo -u postgres psql | |
create role db_user with password 'db_pass'; | |
create database db_name with owner db_user; | |
alter role db_user WITH LOGIN; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment