Dear all:
I am in the trouble shooting mode and need to start somewhere.So I am
turning to you for some advice.
I searched the web and all what I tried did not work. So please bear with
me:
I trying to access a database on a linux machine from a windows computer
using SQuirrel:
postgres version 9.4.5
Squirrell version 3.7
However, I am getting the error message on SQuirrel:
This is the error message I am getting:
Java.util.concurrent.ExecutionException: java.lang.RuntimeException:
org.postgresql.util.PSQLException: Connection to 10.2.44.27:5432 refused.
Check that the hostname and port are correct and that the postmaster is
accepting TCP/IP connections.
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
This is what I have done on the postgres front:
a) Changed postgresql.conf: listen_addresses = '*'
b) edited pg_hba.conf: host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 trust
c) The server is running and listening at the correct port (5432) on the
linux site:
ps -efl | grep postgres
netstat -nlp | grep postgres
In SQirrell I installed the postgres driver and created an alias defining
jdbc:postgresql://hostname/db
Do you happen to know what is going on?
Any input is highly appreciated,
Markus
|