Monday, December 1, 2014

22 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

22 comments:

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

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

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

    crack software free download | burnaware crack

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

    ReplyDelete
  5. 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
  6. 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
  7. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks!


    SAP training in Chennai

    ReplyDelete



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


    SEO Company in Chennai

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

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

    iOS App Development Company

    ReplyDelete

  11. 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
  12. 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
  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...
    Fitness SMS
    Fitness Text
    Salon SMS
    Salon Text
    Investor Relation SMS
    Investor Relation Text

    ReplyDelete
  14. 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

 

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