Opened 2 months ago

Closed 2 weeks ago

#2355 closed task (fixed)

Install pgadmin or replacement

Reported by: kalxas Owned by: osgeolive@…
Priority: major Milestone: OSGeoLive15.0
Component: OSGeoLive Keywords: postgresql
Cc: osgeolive@…

Description

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

Change history (17)

comment:1 by kalxas, 2 months ago

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

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

comment:2 by kalxas, 2 months ago

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

comment:3 by johanvdw, 2 months ago

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

comment:5 by kalxas, 2 months ago

Priority: blockercritical

phppgadmin now added in 15.0alpha1

comment:6 by darkblueb, 7 weeks ago

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

comment:7 by kalxas, 3 weeks ago

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

comment:8 by sanak, 3 weeks ago

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

comment:9 by cvvergara, 3 weeks ago

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

comment:10 by robe, 3 weeks ago

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.

comment:11 by robe, 3 weeks ago

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.

comment:12 by bakaniko, 3 weeks ago

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.

comment:13 by bakaniko, 3 weeks ago

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

comment:15 by kalxas, 2 weeks ago

Priority: criticalmajor

comment:17 by kalxas, 2 weeks ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.