Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Allow to specify 'postgres' user password #40

Open
sauliusgrigaitis opened this issue Jul 9, 2014 · 1 comment
Open

Allow to specify 'postgres' user password #40

sauliusgrigaitis opened this issue Jul 9, 2014 · 1 comment

Comments

@sauliusgrigaitis
Copy link
Contributor

My app database user is restricted user that can not drop or create databases, so db:push fails, because it tries to drop database on behalf of restricted user. I really don't want to change permissions for app database user, so I see two ways how to resolve it:

  1. Allow to pass password for 'postgres' user, so dabatase create/drop will be run on behalf of 'postgres' user.
  2. Truncate tables instead of database drop/create. I don't prefer it, because it's a bit tricky thing on Postgresql.

Any ideas?
@sgruhier
Copy link
Owner

I'm not a postgres expert, if anyone can answer or make a PR, I'll appreciate it
Thanks

@sauliusgrigaitis sauliusgrigaitis mentioned this issue Jun 10, 2015
Closed
sauliusgrigaitis added a commit to sauliusgrigaitis/capistrano-db-tasks that referenced this issue Nov 22, 2015
@sauliusgrigaitis
Allow to specify privileged user for database drop/create (PostgreSQL…
bfe43be 
… only). Solves sgruhier#40
@sauliusgrigaitis sauliusgrigaitis mentioned this issue Nov 22, 2015
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@sgruhier @sauliusgrigaitis