Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Access PostgreSQL using IP address

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 183
    Comment on it

    To add a new server connection using an IP address, you need to follow these steps:

    1. Go to the folder PostgreSQL/data, and edit the file postgresql.conf, add the following line at the end of the file and save:

        listen_addresses = '*'        # what IP address(es) to listen on; 

      '*' - for all the ip addresses or you can mention the IP address you wish to add

    2.  listen_addresses = '192.168. . ' 
    3. In the same directory PostgreSQL/data, open pg_hba.conf with an editor and add the following line:

      host    all         all         192.168. . /32      md5 
    4. Restart your server or from Services.

    5. Add the new connection as we normally do, mention IP in host field.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: