Bug 25778

Summary:	pgadmin3 not supported anymore, update to pgadmin4 needed
Product:	Mageia	Reporter:	Nicolas Pomarède <npomarede>
Component:	RPM Packages	Assignee:	Python Stack Maintainers <python>
Status:	RESOLVED WONTFIX	QA Contact:
Severity:	normal
Priority:	Normal	CC:	doktor5000, mageia, ouaurelien
Version:	7	Keywords:	NEEDINFO
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:	pgadmin3-1.22.2-3.mga7	CVE:
Status comment:
Bug Depends on:	25774
Bug Blocks:

Description Nicolas Pomarède 2019-11-28 13:48:57 CET

hello

while trying to connect to a recent postgresql 10 database at work using pgadmin3 under mga7, I noticed that pgadmin3 doesn't support postgresql > 9.6 and will display a lot of errors.

But mageia7 / cauldron are now providing postgresql 11, so this tools is no more useful for such recent postresql.

On https://www.pgadmin.org/download/ it states :

"WARNING: pgAdmin 3 is no longer supported. It is recommended that you download pgAdmin 4 instead"

Indeed, latest version 1.22.2 is from november 2016

On the opposite, pgadmin4 is now actively developed (latest is v4.15 from nov 2019) and support all postgresql versions.

Proposed solution:
drop pgadmin3 from mageia7 / cauldron and add support for pgadmin4 instead (with backport for mageia7)

See also https://bugs.mageia.org/show_bug.cgi?id=25774 for similar issue with obsolete phppgadmin.

Marc Krämer 2019-11-28 17:00:37 CET

Depends on: (none) => 25774

Comment 1 Marc Krämer 2019-11-28 17:22:08 CET

I've had a look into this tool. Buildprocess requires python and some "flask" modules. Since I'm no python programmer, I'm leaving this package to someone who knows python better than me ;)

CC: (none) => mageia

Comment 2 Nicolas Pomarède 2019-11-28 17:29:10 CET

Maybe it's just the "server" part that runs from local http/https that requires python ?
There's also a desktop part that should be plain C/C++ and not require python.

In the end, perhaps 2 rpms should be provided (server and desktop) ?

Also, pgadmin4 is available in latest fedora, maybe their srpm can be used without too much changes as a starting point ?

Comment 3 Marc Krämer 2019-11-28 17:38:24 CET

at least for build these packages are required. And if I read the build script (requirements) correct, we currently do not have all of the py-packages they require.
As I told, I'm not used to python at all, so I leave this to someone who knows about their packages and syntax.

Comment 4 Lewis Smith 2019-11-28 19:13:54 CET

Thank you Nicolas for your alert; and Marc for looking into it immediately.

In the light of Marc's comments re the Python dependencies we do not currently have, I am assigning this initially to the Python group for their opinion. They can re-assign it afterwards if necessary.

Assignee: bugsquad => python

Comment 5 Aurelien Oudelet 2020-09-10 16:08:26 CEST

Ping this bug report.

Keywords: (none) => NEEDINFO
CC: (none) => ouaurelien

Comment 6 Aurelien Oudelet 2021-07-06 13:17:17 CEST

Mageia 7 is EOL since July 1st 2021.
There will not have any further bugfix for this release.

You are encouraged to upgrade to Mageia 8 as soon as possible.

@reporter, if this bug still apply with Mageia 8, please let us know it.

@packager, if you work on the Mageia 7 version of your package, please check the Mageia 8 package if issue is also present. In this case, please fix the Mageia 8 version instead.

This bug report will be closed OLD if there is no further notice within 1st September 2021.

Comment 7 Florian Hubold 2021-08-10 17:24:32 CEST

pgadmin4 has been packaged and comes with mga8, why keep this bug open?

CC: (none) => doktor5000

Comment 8 Marc Krämer 2021-08-10 17:51:21 CEST

true, we can close this one.

Resolution: (none) => WONTFIX
Status: NEW => RESOLVED