setting up postgresql development in rails with multiple users in database.yml?

Question

I am in the process of migrating my SQL to Postgresql because I want to develop in the same environment as my production.

I installed Postgres and was able to set my database yml file such that rake db:create:all worked with no problems.

However before I pushed, I realized that the username and password of the postgresql database is only available on my computer. I.e. I created the login role on my computer. When my friend who is also developing on the application, pulls the code, he won't have the username and password created by me on my computer.

Is he supposed to also create the same login role? Or is there a way to leave username / password blank so that everyone who develops can access the application? More importantly, what is the best practice for a situation like this?

I am developing on windows and he is on mac.

My database.yml: username and password left out.

development:
  adapter: postgresql
  encoding: unicode
  database: volatility_development
  pool: 5
  timeout: 5000
  host: localhost

test:
  adapter: postgresql
  encoding: unicode
  database: volatility_test
  pool: 5
  timeout: 5000
  host: localhost

production:
  adapter: postgresql
  encoding: unicode
  database: volatility_production
  pool: 5
  timeout: 5000

Patrick Klingemann · Accepted Answer · 2013-03-21 02:57:27Z

2

one possibility would be to use a combination of erb and environment variables, for example:

development:
  username: <%= ENV['USERNAME'] %>
  password: <%= ENV['PASSWORD'] %>
  adapter: postgresql
  encoding: unicode
  database: volatility_development
  pool: 5
  timeout: 5000
  host: localhost

then you could do either of the following:

start your server like so: USERNAME=bob PASSWORD=secret rails s

add the following to your .bashrc

export USERNAME=bob
export PASSWORD=secret

answered Mar 21, 2013 at 2:57

Patrick Klingemann

9,0244 gold badges46 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Spone Over a year ago

You can also use dotenv and store your environment variables in a .env file in your project directory.

Collectives™ on Stack Overflow

setting up postgresql development in rails with multiple users in database.yml?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related