Skip to content

Instantly share code, notes, and snippets.

@newmetl

newmetl/Create new postgre user and setup

Created September 9, 2016 11:39
Show Gist options
  • Save newmetl/310d1a7a2d48bea6b76298daa8b14bba to your computer and use it in GitHub Desktop.
Save newmetl/310d1a7a2d48bea6b76298daa8b14bba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Create new postgre user and setup
createuser -R -S -L -D -I newusername;
psql -d postgres
postgres=# alter role newusername LOGIN;
postgres=# alter role newusername CREATEDB;
postgres=# alter role newusername SUPERUSER; # if needed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment