diff scripts/database/homebrew/create-role-superuser @ 10:a50cf11e5178

Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/database/homebrew/create-role-superuser	Tue Sep 08 17:00:21 2015 +0200
@@ -0,0 +1,3 @@
+#!/bin/sh
+# so you don't have to sudo to postgres to create roles, etc.
+~/.homebrew/bin/psql -c "CREATE ROLE $USER UNENCRYPTED PASSWORD 'secret' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN REPLICATION" template1