[Solved] postgresSQL database case : Need help on install postgis extension and arrangement of remote access to manage database

[chakkrapong2]

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.

[wolstech]

Krydos has to do this. What is the name of the database and database user needing the access and postgis?

[chakkrapong2]

database name is  chakkrapong_geos

databse user: chakkrapong_postgres

 

[wolstech]

Escalating.

[Krydos]

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.

[chakkrapong2]

Thanks , appreciate your help all. I will check and follow suggestion

[chakkrapong2]

thank a lot. postgis extention come aready