Open embario opened 9 years ago
Hi Mario. To use Postgres with Rails on a Linux machine, follow the instructions here: https://github.com/codeforamerica/howto/blob/master/PostgreSQL.md#linux
If you're using Puppet, I think it automatically takes care of the pg_hba.conf
settings in the aforementioned link. Here is an example Vagrant setup for Postgres (although without postgis stuff):
https://github.com/codeforamerica/ohana-api-dev-box/blob/master/puppet/manifests/default.pp#L79-113
Hi there,
I'm part of the Boulder CFA Brigade, and we are interested in using Trailsy for the City of Boulder with OpenTrails Data of the trails in Boulder County (and beyond).
First off, nice work! The app looks really nice, and it's great to have separation of concerns with client and backend. My problem however, is about configuring a postgreSQL database on local setup. I can't seem to connect to the database from the development config under the database.yml file. Here's my config:
It should be said that I am currently using a Vagrant virtual machine to bootstrap the provisioning of nginx, PostgreSQL, Rails, Ruby, and other such stuff so that future development on Trailsy can be done within an encapsulated development environment. That's a pull request in the future.
Here's the problem I run into: when I go to run any of the rake commands to migrate/create seed/create DB, I get a "Peer Authentication Failed for "trails_login" error. I know this is outside of the project scope because it has everything to do with how the DB is set up, but I was wondering if anyone here had expertise on setting up PostgreSQL properly with Rails.
If anyone has knowledge in Vagrant/Puppet, that would be really helpful, too. Here's the part of my manifest dealing with PostgreSQL config:
Thanks in advance! Mario B.