By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Unable to set up or access Postgres on Wireless LAN

P: 1
Hello,
Getting frustrated trying to set up Postgresql on a LAN. I made sure the listen_addresses = '*' 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.
Mar 22 '18 #1
Share this Question
Share on Google+
1 Reply


P: 5
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.
Apr 22 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.