sheikabu Posted May 29, 2017 Share Posted May 29, 2017 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. Quote Link to comment Share on other sites More sharing options...
Krydos Posted May 29, 2017 Share Posted May 29, 2017 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? Quote Link to comment Share on other sites More sharing options...
sheikabu Posted May 29, 2017 Author Share Posted May 29, 2017 database “bma_bookmyarrival”.username: bma_user I am using dynamic IP. Could you please give a permission for all Ips Quote Link to comment Share on other sites More sharing options...
sheikabu Posted May 29, 2017 Author Share Posted May 29, 2017 Could you please update me on this asap Quote Link to comment Share on other sites More sharing options...
wolstech Posted May 29, 2017 Share Posted May 29, 2017 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. Quote Link to comment Share on other sites More sharing options...
Krydos Posted May 29, 2017 Share Posted May 29, 2017 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 inHis IP is from India. Quote Link to comment Share on other sites More sharing options...
wolstech Posted May 29, 2017 Share Posted May 29, 2017 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 inHis IP is from India. I figured he probably wasn't in the USA...I can't see IPs on posts when on my phone... Quote Link to comment Share on other sites More sharing options...
Krydos Posted May 29, 2017 Share Posted May 29, 2017 You should now be able to access the postgresql database bma_bookmyarrival remotely with the postegresql user bma_user from all IPs. Quote Link to comment Share on other sites More sharing options...
sheikabu Posted May 30, 2017 Author Share Posted May 30, 2017 sorry not connecting. please find the details which I tried to connect. I tried this from pgadmin3 Host: heliohost.orgPost: 5432Maintenance DB: postgressUsername: bma_userPassword: <password here> Quote Link to comment Share on other sites More sharing options...
Krydos Posted May 30, 2017 Share Posted May 30, 2017 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. Quote Link to comment Share on other sites More sharing options...
sheikabu Posted May 30, 2017 Author Share Posted May 30, 2017 Hi, I want to access database from pgadmin3. Could you please guide me.. Dataname: bma_bookmyarrivalDb username: bma_user Quote Link to comment Share on other sites More sharing options...
Krydos Posted May 30, 2017 Share Posted May 30, 2017 psql --username=bma_user --dbname=bma_bookmyarrival --host=ricky.heliohost.org --port=5432 Then enter your password for bma_user when prompted. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.