PostgreSQL Administration Tools for Ubuntu 20.04 Virtual Machine running OpenLiteSpeed

[Gorilla]

I deployed a Virtual Machine in Google Cloud Platform Compute Engine using the "OpenLiteSpeed Django" (Ready to run, Django 3 with performance web server) One-Click App found in the Marketplace. The VM uses Ubuntu 20.04. I got OLS to serve two Django/PostgreSQL websites over SSL under different domains using Letsencrypt certificates. Now I want to install pgAdmin4 or some other database administration tool.

To install PostgreSQL I did "apt install postgresql postgresql-contrib -y" as per the VM's documentation at https://docs.litespeedtech.com/cloud/images/django/.

To install pgAdmin4 I tried the procedure at https://www.linuxhowto.net/how-to-install-postgresql-and-pgadmin4-in-ubuntu-20-04/, which depends on apache2 and did not work.

I've found no info on installing and using pgAdmin with OpenLiteSpeed.

Could someone please shed light on the subject of installing and using a good PostgreSQL administration tool for this Virtual Machine?

 

[Cold-Egg]

Here's the example to install phppgadmin for OpenLiteSpeed Django image,

1. Go to /usr/local/lsws/Example/html/ folder and download https://github.com/phppgadmin/phppgadmin/archive/REL_7-13-0.zip
2. apt-get install unzip lsphp74-pgsql -y, then unzip the phppgadmin zip file.
3. Change the folder name, mv phppgadmin-REL_7-13-0 phppgadmin
4. Go to OpenLiteSpeed Web Admin > Virtual Hosts > Example > Context, add a static context
URI = /pg/
Location = /usr/local/lsws/Example/html/phppgadmin/
Accessible= Yes

Then you just need to config the phppgadmin config file, then visit it from http://x.x.x.x/pg/

 

[Gorilla]

Dear Cold-Egg,
That worked. Thanks a lot for your help.