[OSGeoLive] #2355: Install pgadmin or replacement

[OSGeoLive]

#2355: Install pgadmin or replacement
------------------------+----------------------------
 Reporter:  kalxas      |       Owner:  osgeolive@…
     Type:  task        |      Status:  new
 Priority:  critical    |   Milestone:  OSGeoLive15.0
Component:  OSGeoLive   |  Resolution:
 Keywords:  postgresql  |
------------------------+----------------------------
Comment (by robe):

 I was hoping phppgAdmin would be a good enough replacement, but it lacks
 the viewing of the extension section, which is where pgAdmin4 shines.  It
 however does allow you to see the table structures which QGIS DbManager
 seems to lack.

 One thought is to just put in a section on using PSQL, which will allow
 for describing extensions, showing structure of foreign tables etc.  But I
 would still keep the pgAdmin4 section, cause I think it's much less
 intimidating to newcomers than PSQL is.  Also if you are using a fairly
 recent version of ogr_fdw, we can get rid of the going to commandline,
 since ogr_fdw 1.1, there is a ogr_fdw_drivers function.
 https://github.com/pramsey/pgsql-ogr-fdw/releases/tag/v1.1.0

 I'll take a stab and doing an alternative section (using psql instead of
 pgAdmin4), and cleaning it up a bit.
-- 
Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2355#comment:10>
OSGeoLive <https://live.osgeo.org/>
self-contained bootable DVD, USB thumb drive or Virtual Machine based on Lubuntu, that allows you to try a wide variety of open source geospatial software without installing anything.