Skip to content

Instantly share code, notes, and snippets.

@perimetro20

perimetro20/Create database.sql

Created February 2, 2017 16:11
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 perimetro20/1610018d74eb7fb00871dfc76c937285 to your computer and use it in GitHub Desktop.
Save perimetro20/1610018d74eb7fb00871dfc76c937285 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Database configuration
Raw
Create database.sql
CREATE DATABASE project_name_db;
CREATE ROLE project_db_admin WITH LOGIN PASSWORD 'db_admin_password';
GRANT ALL PRIVILEGES ON DATABASE project_name_db TO project_db_admin;
ALTER USER project_db_admin CREATEDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment