PostgreSQL configuration without password on Ubuntu for Rails

postgresql_configuration_on_ubuntu_for_rails.md

Abstract

You could have postgre installed on localhost with password (or without user or password seted after instalation) but if we are developing we really don't need password, so configuring postgre server without password for all your rails project is usefull.

Install Postgre packages

• postgresql
• postgresql-client
• libpq-dev

Install Postgre gem

/Gemfile

gem 'pg'

Configuration

1. Edit postgre configuration file:

    sudo gedit /etc/postgresql/POSTGRE_VERSION/main/pg_hba.conf
   

2. Change all configuration access to:

    # Database administrative login by Unix domain socket
    local   all             all                                     trust
   
    # TYPE  DATABASE        USER            ADDRESS                 METHOD
   
    # "local" is for Unix domain socket connections only
    local   all             all                                     trust
    # IPv4 local connections:
    host    all             all             127.0.0.1/32            trust
    # IPv6 local connections:
    host    all             all             ::1/128                 trust
   

3. Restart postgre server

    sudo /etc/init.d/postgresql restart
   

4. Enjoy :)

Thanks! Running a rails app with trust authentication is surprisingly hard to find help for. You're a lifesaver.

thank you! it's work

Worked like a charm!

Very good!

Nice! Works as expected. Thanks for this. As a Postgres.app user in macos, this is a lifesaver.

thank you so much! it was very helpful!

thanks! )

excuse me ,I failed to install. Can you tell me the command of the second step?

Thank you!!

Thank you and congrats for the content you made.

Thanks! It worked.

Thank you! I created a rails app without --database=postgresql and trying to rails db:create postgres in development was impossible for me without this!

Thank you!

works like a charm:)