Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Access PostgreSQL using IP address

    @dinesh.singh
    Recommendations Offline Message

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 557
    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. . '

    2. 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

    3. Restart your server or from Services.

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

    PostgreSQL
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: