Skip to content

Instantly share code, notes, and snippets.

@muminoff

muminoff/psql.md

Last active August 29, 2015 14:05
Show Gist options
  • Save muminoff/44888e53077487855e14 to your computer and use it in GitHub Desktop.
Save muminoff/44888e53077487855e14 to your computer and use it in GitHub Desktop.
Download ZIP
Create db and user in PostgreSQL
Raw
psql.md

##First login with postgres user

Create role

CREATE ROLE muminoff with LOGIN CREATEDB PASSWORD 'muminoff';

Create database

CREATE DATABASE muminoffdb;

Grant privileges to user on database

GRANT ALL PRIVILEGES ON DATABASE muminoffdb to muminoff;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment