chakkrapong2 Posted August 20, 2023 Share Posted August 20, 2023 Dear sir I am developing web map service and use postgres database with postgis extension I sign up for free server on https://tommy2.heliohost.org/ my site https://geos.helioho.st https://geos.helioho.st/geotech/map_lf.html I need helps on 1. I observe that on my database there is no postgis extension i want to install it very appreciate if u allow and install it for my case. 2. on database management there is no cpanel or tools to manage it so I can only use php coding way to create table. Hense, Is there tool like Pgadmin connect or not which i can remote connect to heliohost databse to manage my database inside it. I need help to provide remote coonect from my local pc using Pgadmin to connect heliohost databse. Link to comment Share on other sites More sharing options...
wolstech Posted August 20, 2023 Share Posted August 20, 2023 Krydos has to do this. What is the name of the database and database user needing the access and postgis? Link to comment Share on other sites More sharing options...
chakkrapong2 Posted August 20, 2023 Author Share Posted August 20, 2023 database name is chakkrapong_geos databse user: chakkrapong_postgres Link to comment Share on other sites More sharing options...
wolstech Posted August 20, 2023 Share Posted August 20, 2023 Escalating. Link to comment Share on other sites More sharing options...
Krydos Posted August 20, 2023 Share Posted August 20, 2023 7 hours ago, chakkrapong2 said: database name is chakkrapong_geos The postgis extension has been installed on this database. 10 hours ago, chakkrapong2 said: 2. on database management there is no cpanel or tools to manage it so I can only use php coding way to create table. Hense, Is there tool like Pgadmin connect or not which i can remote connect to heliohost databse to manage my database inside it. I need help to provide remote coonect from my local pc using Pgadmin to connect heliohost databse. Plesk, like most control panels, has very limited support for PostgreSQL. We recommend installing Adminer https://www.adminer.org/ in your httpdocs directory for managing your PostgreSQL databases through your browser. It's basically just a single file that you configure to connect to your database. Since you mentioned Pgadmin I have also enabled remote connections to your database, but be aware that this reduces the security of your database considerably because it gives hackers access to remotely bruteforce your password. Using Adminer is much more secure. Link to comment Share on other sites More sharing options...
chakkrapong2 Posted August 21, 2023 Author Share Posted August 21, 2023 Thanks , appreciate your help all. I will check and follow suggestion Link to comment Share on other sites More sharing options...
chakkrapong2 Posted August 21, 2023 Author Share Posted August 21, 2023 thank a lot. postgis extention come aready Link to comment Share on other sites More sharing options...
Recommended Posts