valeth/postgresql_configuration_on_ubuntu_for_rails.md

Forked from p1nox/postgresql_configuration_on_ubuntu_for_rails.md

Created June 3, 2017 23:04

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/valeth/5df31b10b2ee88b9a94b10ee6f73bca5.js"></script>
Save valeth/5df31b10b2ee88b9a94b10ee6f73bca5 to your computer and use it in GitHub Desktop.

Download ZIP

PostgreSQL configuration without password on Ubuntu for Rails

Raw

postgres_configuration_on_ubuntu_for_rails.md

Abstract

You could have postgres 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 postgres server without password for all your rails project is usefull.

Install Postgres packages

postgresql
postgresql-client
libpq-dev

Install Postgres gem

# /Gemfile

gem 'pg'

Configuration

Open postgres configuration file from the console

gedit /etc/postgresql/POSTGRE_VERSION/main/pg_hba.conf
Change all local configuration access to:

local all postgres trust
Restart postgres server

sudo /etc/init.d/postgresql restart
Enjoy :)