Bug 25778 - pgadmin3 not supported anymore, update to pgadmin4 needed
Summary: pgadmin3 not supported anymore, update to pgadmin4 needed
Status: RESOLVED WONTFIX
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 7
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: Python Stack Maintainers
QA Contact:
URL:
Whiteboard:
Keywords: NEEDINFO
Depends on: 25774
Blocks:
  Show dependency treegraph
 
Reported: 2019-11-28 13:48 CET by Nicolas Pomarède
Modified: 2021-08-10 17:51 CEST (History)
3 users (show)

See Also:
Source RPM: pgadmin3-1.22.2-3.mga7
CVE:
Status comment:


Attachments

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


Note You need to log in before you can comment on or make changes to this bug.