fudobi Posted September 5 Share Posted September 5 Hey guys, would very much appreciate if I could get remote access for a postgres DB. DATABASE: database: fudobi_suteki user: fudobi_admin_suteki host: fudobi.helioho.st I believe that @Krydos has to do this. Thanks a lot! Quote Link to comment Share on other sites More sharing options...
wolstech Posted September 5 Share Posted September 5 Krydos can do this for you. Quote Link to comment Share on other sites More sharing options...
Krydos Posted September 5 Share Posted September 5 You already have remote access for 7 databases. Do you really still need access to all of these? Also I'm considering adding a limit to the number of remote PostgreSQL access requests because of you. We used to allow unlimited domains, until someone abused our generosity. We used to allow unlimited database connections, until someone abused our generosity. We still allow unlimited PostgreSQL remote access requests, but you may be the person to change that policy. Quote Link to comment Share on other sites More sharing options...
fudobi Posted September 6 Author Share Posted September 6 Hey man. Sorry, don't want to abuse the policy. Maybe you can help me with my use case. But basically what I do is that I connect to a erp system and bring the data via API to then be able to do some data analytics on the data from the ERP. And I built a whole script to do this automatically because it would have been a pain to do it manually. Not trying to have any abuse here and that is also why I contributed on the paid version and willing to scale up if needed. Let me know if this can be done or what is the problem to writing to the DB via API. But truly really sorry, not wanting to abuse anything here. Thanks, Francisco Quote Link to comment Share on other sites More sharing options...
Krydos Posted September 6 Share Posted September 6 Why not reuse a database that already has remote access enabled? Why do you need 8 different databases? Quote Link to comment Share on other sites More sharing options...
fudobi Posted September 7 Author Share Posted September 7 Need to segment the access of each ERP. Cannot have one person looking at all those ERPs. If there is any way to segment row access by a column value inside Postgres that would be amazing!!! Quote Link to comment Share on other sites More sharing options...
Krydos Posted September 7 Share Posted September 7 That's fine. I just needed to make sure you had a good reason for all this, and weren't just screwing around with us or something. Remote access enabled. host=65.19.154.94 port=5432 username=fudobi_admin_suteki dbname=fudobi_suteki password=<set in Plesk> 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.