Skip to content

Instantly share code, notes, and snippets.

@garyharan garyharan/grants.sql

Created Nov 27, 2016
Embed
What would you like to do?
How to setup postgresql properly for phoenix defaults
# run psql command to get to this
# Replace APP_NAME with application name
grant all privileges on database APP_NAME_dev to postgres;
grant all privileges on database APP_NAME_test to postgres;
# where APP_NAME is app name.
createuser -P postgres
createdb APP_NAME_dev
createdb APP_NAME_test
@garyharan

This comment has been minimized.

Copy link
Owner Author

garyharan commented Nov 27, 2016

Of course the order of files is wrong. grants.sql is run second.

@garyharan

This comment has been minimized.

Copy link
Owner Author

garyharan commented Nov 29, 2016

So apparently when I tried to run tests it required a bit more capabilities.

I ran psql with my superuser and then ran ALTER ROLE postgres CREATEDB;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.