Monday, December 1, 2014

68 Enable PostgreSQL for remote connection in Centos 7 with firewall-cmd

Enable client authentication in pg_hba.conf

host    all             all             0.0.0.0/0               md5

Allow TCP/IP connection in postgresql.conf

listen_addresses = '*'          # what IP address(es) to listen on;

Need to restart the service after edit the postgresql.conf

systemctl status postgresql-inst1

Configure firewall-cmd

firewall-cmd --zone=public --add-port=7001/tcp --permanen
firewall-cmd --reload

image

Test connecting with pgadmin3

image

68 comments:

  1. Today I saw your blog and i really love your work Keep it up.
    best free software for windows 8

    ReplyDelete
  2. thank you so much!! its wonderful information.
    cracked software free download | latest software

    ReplyDelete
  3. Thanks a lot for giving this usefull information. I like it so much
    Free Window Software Download | dvd cloner

    ReplyDelete
  4. Get lots of free softwares in a very large amount cracked keygen patch portable versions.

    crack software free download | burnaware crack

    ReplyDelete
  5. I am Very glad. Thanks a lot for giving this useful information.
    latest software free download

    ReplyDelete
  6. Hello admin I really like your website and I really impressed to read your all blogs. Keep it up. Thank you.Ashampoo Burning Studio Crack

    ReplyDelete
  7. These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your articles really impressed for me,because of all information so nice.

    SAP training in Chennai

    ReplyDelete
  8. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks!


    SAP training in Chennai

    ReplyDelete



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


    SEO Company in Chennai

    ReplyDelete
  10. i enjoy to see your work..keep it up...and also visit to my site...for Many working Tips...DVD Cloner 2016 Crack

    ReplyDelete
  11. This post is really nice and informative. The explanation given is really comprehensive and informative..

    iOS App Development Company

    ReplyDelete

  12. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

    Android App Development Company

    ReplyDelete
  13. You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
    iOS App Development Company

    ReplyDelete
  14. You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
    Fitness SMS
    Fitness Text
    Salon SMS
    Salon Text
    Investor Relation SMS
    Investor Relation Text

    ReplyDelete
  15. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

    ReplyDelete
  16. 2. Best Digital Marketing company Anantapur
    Comment: helpful information, thanks for writing and share this information

    ReplyDelete
  17. Great info! I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have. visit website

    ReplyDelete
  18. Most of the time I don’t make comments on websites, but I'd like to say that this article really forced me to do so. Really nice post! prywatnoscwsieci

    ReplyDelete
  19. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck. we need privacy

    ReplyDelete
  20. myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

    ReplyDelete
  21. Wow, this is really interesting reading. I am glad I found this and got to read it. Great job on this content. I like it. lemigliorivpn.com

    ReplyDelete
  22. Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Christmas Gift boxes | Wallet Box

    ReplyDelete
  23. I'm here representing the visitors and readers of your own website say many thanks for many remarkable
    online Python training
    python training in chennai

    ReplyDelete
  24. Great thoughts you got there, believe I may possibly try just some of it throughout my daily life.
    Best Devops online Training
    Online DevOps Certification Course - Gangboard

    ReplyDelete
  25. Thanks for the information, Get the best SQL Database Training in Chennai from Hope Tutors at affordable fees.

    ReplyDelete
  26. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.
    Devops Training in bangalore
    Digital Marketing Training in bangalore
    Data Science Training in bangalore
    Java Training in bangalore

    ReplyDelete
  27. Outstanding blog thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.

    Check out : big data training and placement in chennai
    big data hadoop training in chennai
    big data certification in chennai
    hadoop big data training in chennai

    ReplyDelete
  28. I am read your article and I really like to read it, it’s help me lot of time, keep share like this type of useful and valuable information, I hope you will be post again, am really waiting for your next post, keep working, I am really happy and satisfied with your this article, thanks to read my comment, if any one searching website designing company in India please visit my website.
    Web Designing Company in Delhi

    ReplyDelete
  29. I just want to let you know that I just check out your site and I find it very interesting and informative.. Klik hier

    ReplyDelete
  30. I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you!
    data science course

    ReplyDelete

  31. Get the most advanced Hadoop Course by Professional expert. Just attend a FREE Demo session.
    call us @ 9884412301 | 9600112302
    Hadoop training in chennai | Hadoop training in velachery

    ReplyDelete
  32. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article. thank you for sharing such a great blog with us.
    Selenium online training
    Selenium certification training
    Selenium online course
    Selenium training course

    ReplyDelete
  33. We have highly experienced developer for the best SEO friendly websites for all types of businesses and can help make it profitable at the most economical rates.
    SEO Sydney
    Web Design Company

    ReplyDelete
  34. Excellent blog thanks for sharing The world around is changing at turbo speed. With digital marketing companies booming up at every corner, it can be hard to decide which is the best place for you to begin your online marketing journey. If you are based in Chennai, the answer is plain simple - Adhuntt Media has the best team that cover all your branding needs - SEO, Graphic Design, Logo Design, Social Media Marketing, Google Ads, Competitor Analysis and much more.
    digital marketing agency in chennai

    ReplyDelete
  35. Nice blog thanks for sharing Buy unique easy to maintain indoor plants and exotic garden plants all at the same place - Karuna Nursery - the best nursery garden in Chennai. With our exclusive collection of plants and special deals on bulk orders - you know you are at the right place.
    plant nursery in chennai

    ReplyDelete
  36. Nice blog thanks for sharing Shopping for international cosmetics in Chennai? Look no further, the Pixies Beauty Shop has got your back with hundreds of international brands to choose from, that too with the best value.
    beauty Shop in Chennai

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates