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
Download ZIP

Revisions

  1. @p1nox p1nox revised this gist Jul 29, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgresql_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -15,7 +15,7 @@ You could have postgre installed on localhost with password (or without user or

    ## Configuration

    1. Open postgre configuration file:
    1. Edit postgre configuration file:

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

  2. @p1nox p1nox revised this gist Jul 29, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgresql_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -15,7 +15,7 @@ You could have postgre installed on localhost with password (or without user or

    ## Configuration

    1. Open postgre configuration file from the console
    1. Open postgre configuration file:

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

  3. @p1nox p1nox renamed this gist Jun 26, 2013. 1 changed file with 5 additions and 5 deletions.
    10 changes: 5 additions & 5 deletions ...gres_configuration_on_ubuntu_for_rails.md → ...esql_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,21 +1,21 @@
    # 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.
    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 Postgres packages
    ## Install Postgre packages

    * postgresql
    * postgresql-client
    * libpq-dev

    ## Install Postgres gem
    ## Install Postgre gem
    /Gemfile

    gem 'pg'

    ## Configuration

    1. Open postgres configuration file from the console
    1. Open postgre configuration file from the console

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

    @@ -33,7 +33,7 @@ You could have postgres installed on localhost with password (or without user or
    # IPv6 local connections:
    host all all ::1/128 trust

    3. Restart postgres server
    3. Restart postgre server

    sudo /etc/init.d/postgresql restart

  4. @p1nox p1nox revised this gist Jun 26, 2013. 1 changed file with 12 additions and 2 deletions.
    14 changes: 12 additions & 2 deletions postgres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -19,9 +19,19 @@ You could have postgres installed on localhost with password (or without user or

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

    2. Change all local configuration access to:
    2. Change all configuration access to:

    local all postgres trust
    # 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 postgres server

  5. @p1nox p1nox revised this gist Jun 20, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -17,7 +17,7 @@ You could have postgres installed on localhost with password (or without user or

    1. Open postgres configuration file from the console

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

    2. Change all local configuration access to:

  6. @p1nox p1nox revised this gist Feb 17, 2013. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions postgres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -17,14 +17,14 @@ You could have postgres installed on localhost with password (or without user or

    1. Open postgres configuration file from the console

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

    2. Change all local configuration access to:

    local all postgres trust
    local all postgres trust

    3. Restart postgres server

    sudo /etc/init.d/postgresql restart
    sudo /etc/init.d/postgresql restart

    4. Enjoy :)
  7. @p1nox p1nox revised this gist Feb 17, 2013. 1 changed file with 9 additions and 9 deletions.
    18 changes: 9 additions & 9 deletions postgres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -16,15 +16,15 @@ You could have postgres installed on localhost with password (or without user or
    ## Configuration

    1. Open postgres configuration file from the console

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

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

    ` local all postgres trust `

    local all postgres trust
    3. Restart postgres server

    ` sudo /etc/init.d/postgresql restart `

    sudo /etc/init.d/postgresql restart
    4. Enjoy :)
  8. @p1nox p1nox revised this gist Feb 17, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -11,7 +11,7 @@ You could have postgres installed on localhost with password (or without user or
    ## Install Postgres gem
    /Gemfile

    ` gem 'pg' `
    gem 'pg'

    ## Configuration

  9. @p1nox p1nox revised this gist Feb 17, 2013. 1 changed file with 2 additions and 3 deletions.
    5 changes: 2 additions & 3 deletions postgres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -9,10 +9,9 @@ You could have postgres installed on localhost with password (or without user or
    * libpq-dev

    ## Install Postgres gem
    /Gemfile

    # /Gemfile

    gem 'pg'
    ` gem 'pg' `

    ## Configuration

  10. @p1nox p1nox renamed this gist Feb 14, 2013. 1 changed file with 4 additions and 2 deletions.
    6 changes: 4 additions & 2 deletions postgres_configuration_for_rails.md → ...gres_configuration_on_ubuntu_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,12 +1,14 @@
    # 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 postgresql gem
    ## Install Postgres gem

    # /Gemfile

    @@ -26,4 +28,4 @@

    ` sudo /etc/init.d/postgresql restart `

    4. Enjoy :)
    4. Enjoy :)
  11. @p1nox p1nox revised this gist Feb 14, 2013. 1 changed file with 5 additions and 4 deletions.
    9 changes: 5 additions & 4 deletions postgres_configuration_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -8,21 +8,22 @@

    ## Install postgresql gem

    #/Gemfile
    # /Gemfile

    gem 'pg'

    ## Configuration

    1. Open postgres configuration file from the console

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

    2. Change all local configuration access to:

    `local all postgres trust`
    ` local all postgres trust `

    3. Restart postgres server

    `sudo /etc/init.d/postgresql restart`
    ` sudo /etc/init.d/postgresql restart `

    4. Enjoy :)
  12. @p1nox p1nox revised this gist Feb 14, 2013. 1 changed file with 4 additions and 3 deletions.
    7 changes: 4 additions & 3 deletions postgres_configuration_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -7,21 +7,22 @@
    * 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
    `gedit /etc/postgresql/POSTGRE_VERSION/main/pg_hba.conf`

    2. Change all local configuration access to:

    local all postgres trust
    `local all postgres trust`

    3. Restart postgres server

    sudo /etc/init.d/postgresql restart
    `sudo /etc/init.d/postgresql restart`

    4. Enjoy :)
  13. @p1nox p1nox created this gist Feb 14, 2013.
    27 changes: 27 additions & 0 deletions postgres_configuration_for_rails.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,27 @@
    # 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 :)