Exposing PostgreSQL on vagrant to host OS

I've been working with vagrant lately on a Ruby project and I wanted to the ability to view the PostgreSQL database on the vagrant image through DbVisualizer on my OS X system. This is quite easy to set up in PostgreSQL and vagrant.

1. Add a port forwarding entry to your Vagrantfile: config.vm.network "forwarded_port", guest: 5432, host: 15432. I'm using Vagrant 1.6.3 here. Start/restart your Vagrant image.
2. Edit the pg_hba.conf file on the vagrant image. This file may reside in different areas; ours was in /etc/postgresql/9.1/main/. Change the IPv4 local connections entry from...

   host    all             all             127.0.0.1/32            trust
   

   to

   host    all             all             0.0.0.0/0               trust
   

3. Restart PostgreSQL on the vagrant image: sudo service postgresql restart
4. Configure your database tool to connect to localhost, port 15432.

You should be able to connect to your Vagrant PostgreSQL databases now.