The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Release postgresql for Remote Access

Discussion in 'Database Discussions' started by robsonwr, Jun 19, 2012.

  1. robsonwr

    robsonwr Member

    Joined:
    Jun 21, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Piracicaba - BR
    cPanel Access Level:
    DataCenter Provider
    Good morning friends

    in mysql to release for remote access put%

    postgresql and how?

    postgresql version 8.1 standard cpanel
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello,

    You can allow remote access for a set IP for postgresql by editing /var/lib/pgsql/data/postgresql.conf file for the following two lines:

    Code:
    #listen_addresses = 'localhost'
    #port = 5432
    Uncomment both lines and then revise the localhost one to listen on another remote IP as well:

    Code:
    #listen_addresses = 'localhost,IP#'
    After that, save the file. Then add the following like to the bottom of /var/lib/pgsql/data/pg_hba.conf file:

    Code:
    host all all 0.0.0.0 0.0.0.0 md5
    After that, restart postgresql in WHM or using "/scripts/restartsrv_postgres" without the quotes in root SSH.

    Thanks!
     
  3. robsonwr

    robsonwr Member

    Joined:
    Jun 21, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Piracicaba - BR
    cPanel Access Level:
    DataCenter Provider
    thanks

    perfect
     
Loading...

Share This Page