Opened 12 months ago
Closed 10 months ago
#2355 closed task (fixed)
Install pgadmin or replacement
|Reported by:||kalxas||Owned by:|
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)
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 , 12 months ago
comment:2 by , 12 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...
comment:3 by , 12 months ago
Does the repo offer a source package? We could rebuild it for our ppa?
comment:4 by , 12 months ago
This is the source I could find on that ftp server:
I tried to use the 4.x deb scripts but they did not work:
comment:5 by , 12 months ago
|Priority:||blocker → critical|
phppgadmin now added in 15.0alpha1
comment:6 by , 11 months ago
personally, I tried phpPgAdmin 7.13 ; it seems OK to me
comment:7 by , 10 months 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 , 10 months ago
PostGIS quickstart doc needs to be updated, if pgAdmin4 is not available on ISO.
comment:9 by , 10 months 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 , 10 months 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 , 10 months 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 , 10 months 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 , 10 months ago
@robe, @vicky, can you review the PR please ? https://github.com/OSGeo/OSGeoLive-doc/pull/774
comment:14 by , 10 months ago
pgadmin4 install script has been added for VM only:
comment:15 by , 10 months ago
|Priority:||critical → major|
comment:16 by , 10 months ago
comment:17 by , 10 months ago
|Status:||new → closed|
Support for the pgadmin4 ppa has been committed (without installing the deb package)