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 :)