[Answered] How to connect to my newly-created PostgreSQL database

[systemcr]

Hello everyone,

 

I've created a new PostgreSQL database. However, when I access it from my cPanel, I can't see any section to get the parameters needed to establish a connection from pgAdmin (something like a connection string: hostname, database, etc).

 

Where can I get this information?

 

PD: I've read some users don't have access from remote to their PosgreSQL database as default. I'd like to know if this is true and if so, if somebody could please grant me access.

 

Thanks in advance.

 

[Krydos]

What postgresql username do you want to have remote access to what postgresql database? As far as a connection string it depends on the language you're using. For php running on the server it would look something like

$dbconn = pg_connect("host=localhost dbname=systemcr_database user=systemcr_user password=secret123");

[systemcr]

What postgresql username do you want to have remote access to what postgresql database? As far as a connection string it depends on the language you're using. For php running on the server it would look something like

$dbconn = pg_connect("host=localhost dbname=systemcr_database user=systemcr_user password=secret123");

 

Hi Krydos,

 

Thanks for your response. Exactly, that would be a connecion string for PHP (although I am more interested in a dot-net-like connection string). However, what a I really want to know is which host I need to use (in your example you say "localhost", but I guess my host running in HelioHost should have a different name). This is what I want to find.

 

Thanks again!

[Krydos]

If your script is running on our servers the host is localhost.

[systemcr]

What if I want to connect from the outside?

[wolstech]

You have to specifically request remote access and Krydos has to enable it for you. We need the database name, database user, and the IPs from which you will connect (or you can allow all IPs). 

 

Please make a new topic for a PG remote access request if you need this configured.