Skip to content

Instantly share code, notes, and snippets.

@joryhatton

joryhatton/postgresql_configuration_on_ubuntu_for_rails.md

Forked from p1nox/postgresql_configuration_on_ubuntu_for_rails.md
Created January 29, 2019 19:37
Show Gist options
  • Save joryhatton/deba99b5e079d11ec662c42420bf255a to your computer and use it in GitHub Desktop.
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

  1. Open postgres configuration file from the console

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

  2. Change all local configuration access to:

    local all postgres trust

  3. Restart postgres server

    sudo /etc/init.d/postgresql restart

  4. Enjoy :)

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