Re: Ubuntu and Rails postgresql setup

On 02/24/2016 12:34 AM, Marco Lobbia wrote:
> I am on a Ubuntu 14.04 LTS machine.

I thought I'd chime in since I work with Rails and Postgres on Ubuntu
all day long. :-) 14.04 LTS is fine for both production and development.
(Sounds like you're using Heroku for production in any case.)

> Putting everything together, all the information seems to converge on
> the necessity of creating a database superuser with login name that
> match my Ubuntu user name with:
>
> |sudo -u postgres createuser --superuser $USER|

This is the "normal" way to do it for Rails. It wants a superuser so it
can drop and recreate the database before running tests (`rake test`).
Personally I prefer to give each project a separate non-superuser
Postgres account and start tests with just `rspec spec`, but if you're
new to Rails I recommend going with the approved method.

Also, Rails wants to use Postgres "ident" authentication, which does not
require a password because it trusts that the OS has already
authenticated you. You can avoid this too if you like by adding `host:
localhost` to your `database.yml`, but then you'll need to use a password.

Btw since this is not the Rails mailing list, feel free to email me
personally if you have more Rails-specific questions.

 > According to Heroku
 > <https://devcenter.heroku.com/articles/heroku-postgresql#local-setup>
 > it is necessary "to export the DATABASE_URL environment variable for
 > your app to connect to it when running locally", with:
 > |export DATABASE_URL=postgres:///$(whoami)|

That is if you want to connect to the *remote* database on Heroku (i.e.
probably your *production* database). If you want to connect to your
locally-installed Postgres, you should not set DATABASE_URL.

 > Finally I am wondering whether the choice of installing PostgreSQL
 > through the PostgreSQL apt repository would be safe enough or it would
 > be preferable to install the LTS version of Ubuntu.

Either is fine.

Good luck!
Paul