[Solved] Remote Connection To Ricky (Pgadmin 3)

[sheikabu]

Hi,

 

I have been trying to connect to my PostgreSQL Database remotely using pgAdmin III

 

I use the details

 

ricky.heliohost.org with the usual postgresql port number 5432

Username : bma

Password : <removed>

 

Could you please check this asap.

[Krydos]

Please don't post your password. In case someone saw it before I edited it make sure you change your password.

 

Remote postgresql is only available if you request it. What postgresql user, database, and IP would you like to access remotely?

[sheikabu]

database “bma_bookmyarrival”.
username: bma_user

 

I am using dynamic IP. Could you please give a permission for all Ips

[sheikabu]

Could you please update me on this asap

[wolstech]

Moved to customer service.

 

Please be patient. It can take up to 24 hours for such requests because krydos is the only one who can handle them. In addition, I don't know which country you're in, but its a federal holiday today for the USA where we are based, so support may be slower than normal.

[Krydos]

Also keep in mind that you posted at 4am, and then again at 6am on the morning of a holiday. I was soundly asleep at both times. Please be more patient.

 

In addition, I don't know which country you're in

His IP is from India.

[wolstech]

Also keep in mind that you posted at 4am, and then again at 6am on the morning of a holiday. I was soundly asleep at both times. Please be more patient.

 

In addition, I don't know which country you're in

His IP is from India.

 

I figured he probably wasn't in the USA...I can't see IPs on posts when on my phone...

[Krydos]

You should now be able to access the postgresql database bma_bookmyarrival remotely with the postegresql user bma_user from all IPs.

[sheikabu]

sorry not connecting. please find the details which I tried to connect. I tried this from pgadmin3

 

Host: heliohost.org

Post: 5432

Maintenance DB: postgress

Username: bma_user

Password: <password here>

[Krydos]

The host is wrong. Use

 

host: ricky.heliohost.org

 

Also you don't have remote access to the postgres database. You have remote access to bma_bookmyarrival like you requested.

[sheikabu]

Hi,

 

I want to access database from pgadmin3. Could you please guide me..

 

Dataname: bma_bookmyarrival

Db username: bma_user

[Krydos]

psql --username=bma_user --dbname=bma_bookmyarrival --host=ricky.heliohost.org --port=5432

 

Then enter your password for bma_user when prompted.