Unable to set up or access Postgres on Wireless LAN

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mbailoun
    New Member
    • Mar 2018
    • 1

    Unable to set up or access Postgres on Wireless LAN

    Hello,
    Getting frustrated trying to set up Postgresql on a LAN. I made sure the listen_addresse s = '*' is in the postgresql.conf file, and added the following line in the pg_hba.conf file:

    host all all 0.0.0.0/0 trust

    Yet, whenever I try to connect from another computer on the wireless LAN, either via PG Admin, or ODBC driver, I get a messsage 'Failed to connect, make sure the server is listening .... etc.'

    Appreciate any help you can provide.
  • mcptr
    New Member
    • Apr 2018
    • 5

    #2
    The easiest way to check if you can access the port at all is to telnet to it, e.g:

    telnet you_server_ip 5432

    (I'm assuming your postgres server listens on port 5432). The failure to connect has nothing to do with pg_hba (authentication part).
    Check your firewall as well.

    Comment

    Working...