Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
PostgreSQL configuration without password on Ubuntu for Rails

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

@pori

This comment has been minimized.

Copy link

pori commented Nov 13, 2014

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

@omkz

This comment has been minimized.

Copy link

omkz commented Oct 6, 2016

thank you! it's work

@Epigene

This comment has been minimized.

Copy link

Epigene commented Oct 14, 2017

Worked like a charm!

@Seralto

This comment has been minimized.

Copy link

Seralto commented Oct 24, 2017

Very good!

@jorgeacaballero

This comment has been minimized.

Copy link

jorgeacaballero commented Oct 28, 2017

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

@AlexeyAndrianov

This comment has been minimized.

Copy link

AlexeyAndrianov commented Nov 28, 2017

thank you so much! it was very helpful!

@sadfuzzy

This comment has been minimized.

Copy link

sadfuzzy commented Oct 21, 2018

thanks! )

@MaherMahe

This comment has been minimized.

Copy link

MaherMahe commented Jan 25, 2019

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

@danilocandido

This comment has been minimized.

Copy link

danilocandido commented Jan 29, 2019

Thank you!!

@Tcalura

This comment has been minimized.

Copy link

Tcalura commented Jul 26, 2019

Thank you and congrats for the content you made.

@lastab

This comment has been minimized.

Copy link

lastab commented Jan 7, 2020

Thanks! It worked.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.