Tuesday, September 02, 2014

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: "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               trust


    host    all             all                  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.


  1. thanks for this informative post.. learned a lot

    mobile application development in indore

    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

  2. can you tell me some good tutorials ...

    web designing company in indore

  3. What you can do. That's what I do not and have not ever thought of. friv 5

  4. Great and useful article. Creating content regularly is very tough. Your points are motivated me to move on.

    SEO Company in Chennai


  5. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

    Payday loans in Alabama
    Title loans in South Carolina


  6. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Installment Loans Near Me
    Title loans Near Me
    Cash Advances Near Me

  7. This comment has been removed by the author.

  8. This comment has been removed by the author.

  9. It is really a great and useful piece of info. I’m glad that you shared this helpful info with us. Please keep us informed like this. Thank you for sharing.
    Seo Company in Chennai
    Digital Marketing Company in Chennai

  10. Anonymous4:13 AM

    Nice blog..! I really loved reading through this article. Thanks for sharing such a
    amazing post with us and keep blogging... iot training in chennai | iot training in chennai quora | iot training and placement in chennai | iot training center in chennai | best iot training centre in chennai

  11. Thank you for sharing

  12. Thanks for sharing this information. Today, Emblix as one of the best and top most service-oriented Digital Marketing Agency in Hyderabad and India , Which provides high-quality result-oriented Digital Services ranging from SEO to Web Design, Social Media Marketing and more, to a broad spectrum of clients from diverse industry segments. Through a well-oiled combination of Quality Solutions, Transparent Pricing, helping brands connect with customers, Flexible Delivery & Contract Model with a firm commitment to deliver on time and to budget, Emblix has successfully built a strong relationship with clients based on mutual trust and respect. Emblix solutions-digital marketing company

  13. Very nice blog and information. Hope you will update it asap. Tech Arbiters (

  14. Enjoyed reading the article above , really explains everything in detail.
    Best Astrologer in Bangalore


  15. Good Blog, Such a Nice Content, Informative for Readers Keep Posting.
    Best digital marketing company in Bangalore
    Best Astrologer in Bangalore

  16. Nice blog..! I really loved reading through this article... Thanks for sharing such an amazing post with us and keep blogging...
    Best Astrologer in Bangalore
    Best Astrologer in Bangalore

  17. Thanks to share. All our, aspires to be successful. However, they are not always in the same way. If You are in side of astrology? Believe, It occurs as a result of planets that are feeble. Took a sort to get best birth chart horoscope predictions with Pandit sai Jagannatha Famous Astrologer in Bangalore

  18. Excellent post Keep up the good work
    Please look here at
    Vashikaran Astrologer in BTM Layout

  19. Thanks for providing this information. It's very helpful.
    Visit Best Astrologer in Nizamabad

  20. Good astrologycal post,thank you for sharing with community.
    For sofa repair work contact thesofastore gives
    Sofa Refurbishing in Bellandur,Bangalore

  21. This comment has been removed by the author.

  22. Get the best update of the Scope of Hadoop Technology and job opportunities for it from the best software training institute in Chennai, Infycle Technologies. Call +91-7504633633, +91-7502633633 to get the amazing offers and free demo for having Big Data hadoop training in Chennai.

  23. This is extremely enlightening blog.
    Visit Best Indian Astrologer in Delta.