Monday, December 1, 2014

15 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

15 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

 

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