Skip to content

Instantly share code, notes, and snippets.

@unnitallman

unnitallman/create_postgres_database_and_user.md

Created March 20, 2019 08:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save unnitallman/40584a482b415477a333e1ba44f4d543 to your computer and use it in GitHub Desktop.
Save unnitallman/40584a482b415477a333e1ba44f4d543 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_postgres_database_and_user.md 
sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment