Install pgadmin or replacement

[kalxas]

On OSGeoLive 14.0 we introduced pgadmin4 (version 4.x).

For Ubuntu 22.04 pgadmin4 (version 6.x) is available but the packaging is completely different this time. Instead of using the python3 upstream packages, the new deb bundles all nodejs and python libraries in /usr/pgadmin4, taking up lots of disk space (more than 200MB)

See ​https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/README

Also a desktop version is offered as an option.

We need to clarify if we can sacrifice this disk space or seek alternatives (e.g. phppgadmin looks ok and is offered by ubuntu upstream packages) ​https://packages.ubuntu.com/jammy/phppgadmin

[kalxas]

Support for the pgadmin4 ppa has been committed (without installing the deb package)

​https://github.com/OSGeo/OSGeoLive/commit/97d65569824ec31b2969bd0fcb0c3665c9395eac

[kalxas]

Unfortunately, when the pgadmin4 ppa is enabled, a more recent version of libpq5 is added in the disk, breaking grass and potentially other packages...

​https://github.com/OSGeo/OSGeoLive/commit/df66a5e7e5d0e820cf3576ae45bd8e60b3f8dd00

[johanvdw]

Does the repo offer a source package? We could rebuild it for our ppa?

[kalxas]

This is the source I could find on that ftp server:

​https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v6.10/source/pgadmin4-6.10.tar.gz

I tried to use the 4.x deb scripts but they did not work:

​https://launchpad.net/~osgeolive/+archive/ubuntu/nightly/+sourcefiles/pgadmin4/4.25-1~focal0/pgadmin4_4.25-1~focal0.debian.tar.xz

[kalxas]

phppgadmin now added in 15.0alpha1

[darkblueb]

personally, I tried phpPgAdmin 7.13 ; it seems OK to me

[kalxas]

Does everyone agree to add pgadmin4 to VM only or should we drop something else to make pgadmin4 fir into the iso as well?

[sanak]

PostGIS quickstart doc needs to be updated, if pgAdmin4 is not available on ISO.

• ​PostGIS Quickstart
  • :
  • ​Get to know pgAdmin
  • ​Executing a SQL query from pgAdmin
  • :

[cvvergara]

If pgAdmin4 ends in vmdk, I will put a note on those sections that pgAdmin4 is only on vmdk. Thanks for noticing

[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.

[robe]

On second thought I guess it's too late to be making big changes, so I think just putting that it will be on the vmdk only is fine. psql section we can revisit next year.

[bakaniko]

I'm working on adding a phppgadmin section. I suggest to have both version in the doc with a comment indicating where you can use it. I suppose that phppgadmin will be present in both versions.

Yes @robe, let's keep psql for next year.

[bakaniko]

@robe, @vicky, can you review the PR please ? ​https://github.com/OSGeo/OSGeoLive-doc/pull/774

[kalxas]

pgadmin4 install script has been added for VM only:

​https://github.com/OSGeo/OSGeoLive/commit/94ff373a25c2714700549c6803f31731cb61ac9f

[kalxas]

​https://github.com/OSGeo/OSGeoLive/commit/2f9b1cac5fa2437409b9939d0699fd227753df9e