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.

Postgre access

Discussion in 'General Discussion' started by maxihost2, Sep 2, 2005.

  1. maxihost2

    maxihost2 Well-Known Member
    PartnerNOC

    Joined:
    Feb 28, 2005
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    How can I set up Postgresql to accept IP connections ?
    My user is enabling his IP from control panel but it seems that postgresql is not accepting the incoming connection.

    Thank you.
     
  2. ecwebtechie

    ecwebtechie Well-Known Member

    Joined:
    Mar 22, 2005
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    bt default postgres will allow connections only from localhost

    edit this file enter the ip address , dbname and password auth type

    /var/lib/pgsql/data/pg_hba.conf
     
  3. maxihost2

    maxihost2 Well-Known Member
    PartnerNOC

    Joined:
    Feb 28, 2005
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    What I see is:

    local all all md5
    host all all 127.0.0.1 255.255.255.255 md5

    Can you give me please an example to add ? :)
     
  4. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
Loading...

Share This Page