Skip to content

Instantly share code, notes, and snippets.

@carymrobbins

carymrobbins/setup-postgresql-vagrant.md

Last active May 4, 2023 10:22
Show Gist options
  • Save carymrobbins/39b75df64a1201407c80 to your computer and use it in GitHub Desktop.
Save carymrobbins/39b75df64a1201407c80 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,8 @@
    Configure Postgres
    ------------------

    * Update **pg_hba.conf** (most likely in **/etc/postgresql/9.4/main**) with `host all all 0.0.0.0/0 trust`
    * Update **pg_hba.conf** (most likely in **/etc/postgresql/9.4/main**) with -
    * `host all all 0.0.0.0/0 trust`
    * Update **postgresql.conf** to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

  2. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 1 addition and 3 deletions.
    4 changes: 1 addition & 3 deletions setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,9 +2,7 @@
    Configure Postgres
    ------------------

    * Update **pg_hba.conf** (most likely in **/etc/postgresql/9.4/main**) with -
    * `host all all 0.0.0.0/0 trust`
    * You can, alternatively, set the IP to something more specific.
    * Update **pg_hba.conf** (most likely in **/etc/postgresql/9.4/main**) with `host all all 0.0.0.0/0 trust`
    * Update **postgresql.conf** to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

  3. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ Configure Postgres

    * Update **pg_hba.conf** (most likely in **/etc/postgresql/9.4/main**) with -
    * `host all all 0.0.0.0/0 trust`
    * (you can, alternatively, set the IP to something more specific)
    * You can, alternatively, set the IP to something more specific.
    * Update **postgresql.conf** to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

  4. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,16 +2,16 @@
    Configure Postgres
    ------------------

    * Update `pg_hba.conf` (most likely in `/etc/postgresql/9.4/main`) with -
    * Update **pg_hba.conf** (most likely in **/etc/postgresql/9.4/main**) with -
    * `host all all 0.0.0.0/0 trust`
    * (you can, alternatively, set the IP to something more specific)
    * Update `postgresql.conf` to use `listen_addresses = '*'`
    * Update **postgresql.conf** to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

    Configure Vagrant
    -----------------

    * Add `config.vm.network :forwarded_port, host: 5432, guest: 5432` to the `Vagrant.configure` block in your `Vagrantfile`.
    * Add `config.vm.network :forwarded_port, host: 5432, guest: 5432` to the `Vagrant.configure` block in your **Vagrantfile**.

    Test your connection
    --------------------
  5. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -3,8 +3,8 @@ Configure Postgres
    ------------------

    * Update `pg_hba.conf` (most likely in `/etc/postgresql/9.4/main`) with -
    * * `host all all 0.0.0.0/0 trust`
    * * (you can, alternatively, set the IP to something more specific)
    * `host all all 0.0.0.0/0 trust`
    * (you can, alternatively, set the IP to something more specific)
    * Update `postgresql.conf` to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

  6. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -3,8 +3,8 @@ Configure Postgres
    ------------------

    * Update `pg_hba.conf` (most likely in `/etc/postgresql/9.4/main`) with -
    ** `host all all 0.0.0.0/0 trust`
    ** (you can, alternatively, set the IP to something more specific)
    * * `host all all 0.0.0.0/0 trust`
    * * (you can, alternatively, set the IP to something more specific)
    * Update `postgresql.conf` to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

  7. carymrobbins revised this gist Jan 8, 2015. 1 changed file with 3 additions and 2 deletions.
    5 changes: 3 additions & 2 deletions setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,8 +2,9 @@
    Configure Postgres
    ------------------

    * Update `pg_hba.conf` (most likely in `/etc/postgresql/9.4/main`) with `host all all 0.0.0.0/0 trust`
    (you can, alternatively, set the IP to something more specific)
    * Update `pg_hba.conf` (most likely in `/etc/postgresql/9.4/main`) with -
    ** `host all all 0.0.0.0/0 trust`
    ** (you can, alternatively, set the IP to something more specific)
    * Update `postgresql.conf` to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

  8. carymrobbins created this gist Jan 8, 2015.
    18 changes: 18 additions & 0 deletions setup-postgresql-vagrant.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,18 @@

    Configure Postgres
    ------------------

    * Update `pg_hba.conf` (most likely in `/etc/postgresql/9.4/main`) with `host all all 0.0.0.0/0 trust`
    (you can, alternatively, set the IP to something more specific)
    * Update `postgresql.conf` to use `listen_addresses = '*'`
    * Be sure to `sudo service postgresql restart`

    Configure Vagrant
    -----------------

    * Add `config.vm.network :forwarded_port, host: 5432, guest: 5432` to the `Vagrant.configure` block in your `Vagrantfile`.

    Test your connection
    --------------------

    * Attempt to connect from your host using `psql -h localhost -U vagrant`