Skip to content

Instantly share code, notes, and snippets.

@marshallmick007

marshallmick007/postgres_new_db.shs

Created December 26, 2017 17:46
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 marshallmick007/a20ff477e2027e7a7d792b6e0aa302ce to your computer and use it in GitHub Desktop.
Save marshallmick007/a20ff477e2027e7a7d792b6e0aa302ce to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres_new_db.shs
su - postgres
createdb {databasename}
psql {databasename}
databasename=# CREATE USER tester WITH PASSWORD 'test_password';
databasename=# GRANT ALL PRIVILEGES ON DATABASE "databasename" to tester;
databasename=# \q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment