Hello

I tried to connect to PostgreSQL from my simple java code (on the same server), but received following error:

Code:

Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

What should I do to succesfully connect to the database?
PostgreSQL has been installed via Webmin and works properly (I can add tables etc. using virtualmin).

Few details:
Same error message for local and remote calls.
When I type: netstat -ln --tcp I don't see any open 5432 port. Does postgres installed by webmin run on another port?
I have a latest stack of virtualmin/webmin/usermin installed automatically on Debian 40 etch minimal.
Besides I know this is not a local/remote access problem I set this special "any network host" in webmin/servers/PostgreSQL Database Server/Allowed Hosts but there is no difference - error still exists.

Thanks in advance for help!

Hi avedave,

I had a similar problem a while ago but I resolved it by modifying the pg_hba.conf file in my shell console.

If you could post up your pg_hba.conf, I might be able to tell you what is wrong with your configuration.

Regards,
Calvin