joryhatton/postgresql_configuration_on_ubuntu_for_rails.md

Forked from p1nox/postgresql_configuration_on_ubuntu_for_rails.md

Created January 29, 2019 19:37

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

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/joryhatton/deba99b5e079d11ec662c42420bf255a.js"></script>
Save joryhatton/deba99b5e079d11ec662c42420bf255a 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

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment