Bug 1771823

Summary: pgAdmin 3 is no longer supported upstream
Product: [Fedora] Fedora Reporter: Daniel Alley <dalley>
Component: pgadmin3Assignee: Devrim Gündüz <devrim>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 32CC: devrim, stuart
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: pgadmin3-1.23.0b-1.gitea327ac.fc32 pgadmin3-1.23.0b-1.gitea327ac.fc33 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-01-01 01:24:39 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Daniel Alley 2019-11-13 04:20:04 UTC
According to the pgAdmin website, "pgAdmin 3 is no longer supported. It is recommended that you download pgAdmin 4 instead." According to their releases page, the last release of pgAdmin 3 was in 2016.

By comparison, the version of postgresql being shipped in Fedora 30 is 11.5 which came out this year - 3 years after pgAdmin 3. Probably there are a lot of features in PostgreSQL 11 that are not supported in pgAdmin 3, though I have not tried it to know for sure.

Regardless, this package should be dropped.

pgAdmin 4 is available as an RPM on their download page. It might be possible to bring that package into Fedora proper, and perhaps the pgAdmin maintainers would be willing to maintain it.

https://www.pgadmin.org/download/

Comment 1 Daniel Alley 2019-11-13 04:23:30 UTC
Sidenote: This would have other benefits for Fedora because pgAdmin relies on gtk2 and several Xorg-specific libraries. Many projects still rely on these libraries but they are slowly going away, and dropping/replacing this package would help facilitate that process.

Comment 2 Stuart D Gathman 2019-11-13 14:58:09 UTC
No one has packaged pgadmin4 for Fedora yet.  Furthermore, pgadmin4 is essentially a webapp - it doesn't replace pgadmin3.  I think you need electron or something to package it for Fedora.  Pgadmin3 is still the best "real" local app for Postgresql.  It is sad that it is no longer supported.  (*** starts muttering about young people and their obsession with Javascript)

E.g. from the pgadmin4 FAQ:


    As pgAdmin is a web application, it can only interact with the local filesystem in ways that are allowed by modern web browsers. This limits what is possible for security; essentially files can only be "downloaded" or "uploaded" (through a form). There is no way to simply save an update to a file by hitting a Save button, nor is it possible to save the working directory for example.
    When running in server mode, files are read from and stored on the server to enable users to work with the same data whatever machine they happen to be using. There are no "native dialogues" for working with files stored on a web server in this way, so we have to implement our own.

Comment 3 Ben Cotton 2020-02-11 17:46:23 UTC
This bug appears to have been reported against 'rawhide' during the Fedora 32 development cycle.
Changing version to 32.

Comment 4 Stuart D Gathman 2020-11-27 23:56:03 UTC
We are getting patches from https://github.com/allentc/pgadmin3-lts, maybe we should make that the reference source for the Fedora package.

Comment 5 Fedora Update System 2020-12-23 11:21:53 UTC
FEDORA-2020-2aafb0adfb has been submitted as an update to Fedora 32. https://bodhi.fedoraproject.org/updates/FEDORA-2020-2aafb0adfb

Comment 6 Fedora Update System 2020-12-23 11:21:54 UTC
FEDORA-2020-735b970747 has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2020-735b970747

Comment 7 Fedora Update System 2020-12-24 01:10:07 UTC
FEDORA-2020-2aafb0adfb has been pushed to the Fedora 32 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2020-2aafb0adfb`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-2aafb0adfb

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 8 Fedora Update System 2020-12-24 02:04:31 UTC
FEDORA-2020-735b970747 has been pushed to the Fedora 33 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2020-735b970747`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-735b970747

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 9 Fedora Update System 2021-01-01 01:24:39 UTC
FEDORA-2020-2aafb0adfb has been pushed to the Fedora 32 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 10 Fedora Update System 2021-01-01 02:09:53 UTC
FEDORA-2020-735b970747 has been pushed to the Fedora 33 stable repository.
If problem still persists, please make note of it in this bug report.