Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2014
    Posts
    16

    Unanswered: Unable to connect to PGSQL remotely

    Hi,

    I have a PostgreSQL server running on a Linux server. I changed the pg_hba.conf file as follows:

    # "local" is for Unix domain socket connections only
    local all all trust
    # IPv4 local connections:
    host all all all password
    # IPv6 local connections:
    host all all all trust

    restarted Postgresql server and tried to connect to it via a PGAdmin from a windows computer but it still wont connect.

    Can anyone tell me if there is something else i need to check in order to connect to the DB?

    Thanks
    Pankaj

  2. #2
    Join Date
    Apr 2014
    Posts
    16

    Unable to connect to Postgresql DB remotely

    Hi,

    I have postgresql DB running on a Linux server and I am trying to connect to it from a PGAdmin on a Window smachine. I made the following changes to the pg_hba.conf file:

    local all all trust
    # IPv4 local connections:
    host all all all password
    # IPv6 local connections:
    host all all all trust

    restarted pgsql service on Linux but still unable to connect via PGAdmin.

    Can someone tell me if I am misisng a step?

    Thanks
    Pankaj

  3. #3
    Join Date
    Apr 2014
    Posts
    16

    Unable to connect to PGSQL remotely

    Hi,

    I have postgresql DB running on a Linux server and I am trying to connect to it from a PGAdmin on a Window smachine. I made the following changes to the pg_hba.conf file:

    local all all trust
    # IPv4 local connections:
    host all all all password
    # IPv6 local connections:
    host all all all trust

    restarted pgsql service on Linux but still unable to connect via PGAdmin.

    Can someone tell me if I am misisng a step?

    Thanks
    Pankaj

  4. #4
    Join Date
    Aug 2011
    Posts
    42
    Try Disabling Windows Firewall on server/client

    Try accessing system on network

  5. #5
    Join Date
    Mar 2014
    Posts
    20
    And check your logfiles, if you're logging connections you should see failed attempts and can diagnose from there.

  6. #6
    Join Date
    Apr 2014
    Posts
    16
    Thanks all.

    ran /etc/init.d/iptables stop and was able to connect successfully to the DB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •