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.

Connect to Remote PostgreSQL

Discussion in 'Database Discussions' started by 247hostingnz, Jan 21, 2011.

  1. 247hostingnz

    247hostingnz Member

    Joined:
    Jan 21, 2011
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Zealand
    We have a client who wants to connect to a Remote PostgreSQL database.

    We have allowed the port in your firewall but it isn't following through and reaching the remote database.

    Any ideas?
     
  2. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    447
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    There is this link at the bottom of the page in "Similar threads" that has an internal case associated for the same functionality. I believe cPanel staff might be able to provide you a status update on whether this utility has been implemeted.
     
  3. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Do you have "root" (Administrator) access to the remote system hosting the PostgreSQL server?

    I recommend verifying that the remote PostgreSQL server is setup to listen for TCP connections, as configured in the following file:
    Code:
    /var/lib/pgsql/data/postgresql.conf
    The following commands, entered via root SSH access, will help verify the PgSQL configuration status for TCP/IP connectivity:
    Code:
    # egrep -i "(listen_addresses|port|tcpip_socket).*=.+" /var/lib/pgsql/data/postgresql.conf
    # lsof +c0 -anPiTCP -upostgres
    The directives, other than for the port number, may vary depending on the installed version of PostgreSQL. In a stock-default installation they may also be commented and, thus, not active; however, each may be manually uncommented as shown in the following examples:
    • For PostgreSQL version 7.x
      Code:
      tcpip_socket = true
      port = 5432
    • For PostgreSQL version 8.x
      Code:
      listen_addresses = 'localhost'
      port = 5432
     
Loading...

Share This Page