[Solved] which is the host for postgres?

[univalle]

hello all,

 

I have a Java application with which I need to connect to PostgreSQL database

I am using the following code

 

String url = "____", usr= "_____", password="______"

Connection c = DriverManager.getConnection(url, usr, password);

 

to connect to the database

jdbc driver is fine and I tried it locally

 

The problem I have is with 'url', no place to address

or does the heliohost server can not be accessed remotely?

 

My host is bdunivalle.heliohost.org

 

thanks

[Guest Geoff]

Host is stevie.heliohost.org if you are on stevie, johnny.heliohost.org if you are on johnny.

[univalle]

Host is stevie.heliohost.org if you are on stevie, johnny.heliohost.org if you are on johnny.

 

hi Geoff,

 

I am on johnny

 

which is the port? 5432?

 

because, I try

url = "jdbc: postgresql: / / johnny.heliohost.org: 5432/univalle_prueba"

 

my database is univalle_prueba

 

and I could not access, the error is:

 

org.postgresql.util.PSQLException: Connection refused. Verify that the host name and port are correct and that the postmaster is accepting TCP / IP.

 

thanks

[Guest Geoff]

Hmm... I can't seem to connect to johnny postgresql remotely.

[Guest Geoff]

This support request is being escalated to our root admin.

[Ashoat]

Unfortunately, PostgreSQL does not have an easy way to individually enable remote access. The IP access control list is in the main config file, and cPanel doesn't have a utility to manage that list.

[Guest Geoff]

Can't you just put a wildcard in the access file? Would that be too much of a security risk?

[Ashoat]

I think it would be too dangerous... though maybe not. Do you think it makes sense?

[Guest Geoff]

I really don't know; I guess we could collect some opinions from some of our users on this.

 

Hmm... this could be part of HelioPanel, if I ever get started on that.