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_for_rails.md

Abstract

Install Postgres packages

  • postgresql
  • postgresql-client
  • libpq-dev

Install postgresql 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