Management tool for PostgreSQL

Edit Package pgadmin4

pgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL
(http://www.postgresql.org) database.
pgAdmin 4 is written as a web application in Python, using jQuery and Bootstrap
for the client side processing and UI. On the server side, Flask is being utilised.

Although developed using web technologies, we intend for pgAdmin 4 to be usable
either on a web server using a browser, or standalone on a workstation. The
runtime/ subdirectory contains a QT based runtime application intended to allow
this - it is essentially a browser and Python interpretor in one package which
will be capable of hosting the Python application and presenting it to the user
as a desktop application.

Refresh
Refresh
Source Files
Filename Size Changed
README.SUSE 0000001770 1.73 KB
README.SUSE.uwsgi.in 0000000419 419 Bytes
fix-python-lib.patch 0000001303 1.27 KB
fix-python3-crypto-call.patch 0000002692 2.63 KB
pgadmin4-4.30.tar.gz 0036490656 34.8 MB
pgadmin4-4.30.tar.gz.asc 0000000833 833 Bytes
pgadmin4.changes 0000074226 72.5 KB
pgadmin4.conf.in 0000000750 750 Bytes
pgadmin4.desktop.in 0000000319 319 Bytes
pgadmin4.keyring 0000003167 3.09 KB
pgadmin4.qt.conf.in 0000000099 99 Bytes
pgadmin4.service.in 0000000827 827 Bytes
pgadmin4.spec 0000016753 16.4 KB
pgadmin4.tmpfiles.d 0000000039 39 Bytes
pgadmin4.uwsgi.in 0000000270 270 Bytes
use-os-makedirs.patch 0000000608 608 Bytes
Revision 19 (latest revision is 27)
Dominique Leuenberger's avatar Dominique Leuenberger (dimstar_suse) accepted request 870250 from Antonio Larrosa's avatar Antonio Larrosa (alarrosa) (revision 19)
- Fix typos (chmod being used instead of chown in %postun web and
  pgadmin4 used in the service file for User/Group keys instead of
  pgadmin)

- the system wide service does not need to run as root. switch to
  user/group pgadmin 

- Update to 4.30 
  - Features:
    - ERD Tool (Beta): The Entity-Relationship Diagram (ERD) tool
      is a database design tool that provides a graphical
      representation of database tables, columns, and
      inter-relationships. You can use the ERD tool to design a new
      schema and generate the SQL required to create it, or to
      reverse engineer and diagram an existing database schema.
    - Kerberos support is added in pgAdmin 4 using SPNEGO for
      logging into pgAdmin, similar to the existing LDAP and
      "internal" options. Note that support for logging into
      database servers using Kerberos is not included in this
      release, but will be added in a future version.
    - Add a container option (PGADMIN_DISABLE_POSTFIX) to disable
      the Postfix server: Postfix (like other MTAs) must start as
      user 'root', and the pgAdmin container achieves this using
      'sudo'. Whilst that works well in most environments, it can
      cause problems in some. This option allows you to completely
      disable Postfix to avoid these issues, though you will need
      to configure an external mail server to be used to send
      password reset emails.
  - Bugs/Housekeeping:
    - Improve the explain plan details by showing a popup instead
Comments 8


Joseph Gibson's avatar

It's been updated for March 2020, could you update it here, too?


V A's avatar

Does not work in openSUSE Tumbleweed 20220627.

It starts and takes a long time to load pgadmin server. Then it gives the message box "The pgAdmin 4 server could not be contacted."


Giuseppe Stoduto's avatar

Good evening. I was using pgADmin4 in the 4.30 version which is now in the official repositories of openSUSE Tumbleweed. Unfortunately, this version configured as SERVER_MODE = false does not work. I installed the new 6.11 version from Pip and it seems to have no problems. Is it also possible to update the official version of openSUSE?


Andreas Schneider's avatar

Edit /etc/pgadmin/config_system.py and comment in # SERVER_MODE = True?


Giuseppe Stoduto's avatar

Yes. It is an error known for that version resolved with the new version following 6.9. Unfortunately I lost the link of the bug yes Postgres

This is the Issue https://redmine.postgresql.org/issues/6186


Andreas Schneider's avatar

I've tried pgadmin4 on my server and it doesn't work at all. We need to update to version 6.x but it has a lot of changes ...


Giuseppe Stoduto's avatar

I was trying and making changes to the Spec File but my knowledge of the compilation of the RPM programs is very limited. This is why I wrote you here. I wanted to make you aware of the problem. I was trying and making changes to the Spec File but my knowledge of the compilation of the RPM programs is very limited. This is why I wrote you here. I wanted to make you aware of the problem. Another way is to create a Bugrepo on Bugzilla and see if other people more competent than me can help

openSUSE Build Service is sponsored by