How To Install pgadmin3 on Fedora 34

pgadmin3 is Graphical client for PostgreSQL

Introduction

In this tutorial we learn how to install pgadmin3 on Fedora 34.

What is pgadmin3

pgAdmin III is a powerful administration and development platform for the PostgreSQL database, free for any use. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. No additional drivers are required to communicate with the database server.

We can use yum or dnf to install pgadmin3 on Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install pgadmin3.

Install pgadmin3 on Fedora 34 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

After updating yum database, We can install pgadmin3 using dnf by running the following command:

sudo dnf -y install pgadmin3

Install pgadmin3 on Fedora 34 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

After updating yum database, We can install pgadmin3 using yum by running the following command:

sudo yum -y install pgadmin3

How To Uninstall pgadmin3 on Fedora 34

To uninstall only the pgadmin3 package we can use the following command:

sudo dnf remove pgadmin3

pgadmin3 Package Contents on Fedora 34

/usr/bin/pgadmin3
/usr/lib/.build-id
/usr/lib/.build-id/b7
/usr/lib/.build-id/b7/d85138391a108ec338bbe5256e2b27a5bb57b1
/usr/share/applications/pgadmin3.desktop
/usr/share/doc/pgadmin3
/usr/share/doc/pgadmin3/BUGS
/usr/share/doc/pgadmin3/CHANGELOG
/usr/share/doc/pgadmin3/README
/usr/share/doc/pgadmin3/en_US
/usr/share/doc/pgadmin3/en_US/.buildinfo
/usr/share/doc/pgadmin3/en_US/_images
/usr/share/doc/pgadmin3/en_US/_images/backup-2.png
/usr/share/doc/pgadmin3/en_US/_images/backup-3.png
/usr/share/doc/pgadmin3/en_US/_images/backup-4.png
/usr/share/doc/pgadmin3/en_US/_images/backup-5.png
/usr/share/doc/pgadmin3/en_US/_images/backup.png
/usr/share/doc/pgadmin3/en_US/_images/debugger.png
/usr/share/doc/pgadmin3/en_US/_images/editgrid.png
/usr/share/doc/pgadmin3/en_US/_images/export.png
/usr/share/doc/pgadmin3/en_US/_images/gqb.png
/usr/share/doc/pgadmin3/en_US/_images/grantwiz.png
/usr/share/doc/pgadmin3/en_US/_images/gridopt-filter.png
/usr/share/doc/pgadmin3/en_US/_images/gridopt-sort.png
/usr/share/doc/pgadmin3/en_US/_images/guru-connect.png
/usr/share/doc/pgadmin3/en_US/_images/main.png
/usr/share/doc/pgadmin3/en_US/_images/maintenance.png
/usr/share/doc/pgadmin3/en_US/_images/manage-macros.png
/usr/share/doc/pgadmin3/en_US/_images/no-hba.png
/usr/share/doc/pgadmin3/en_US/_images/not-running.png
/usr/share/doc/pgadmin3/en_US/_images/options-binary_paths.png
/usr/share/doc/pgadmin3/en_US/_images/options-colours.png
/usr/share/doc/pgadmin3/en_US/_images/options-database_designer.png
/usr/share/doc/pgadmin3/en_US/_images/options-display.png
/usr/share/doc/pgadmin3/en_US/_images/options-favourites.png
/usr/share/doc/pgadmin3/en_US/_images/options-guru_hints.png
/usr/share/doc/pgadmin3/en_US/_images/options-help_paths.png
/usr/share/doc/pgadmin3/en_US/_images/options-history_file.png
/usr/share/doc/pgadmin3/en_US/_images/options-logging.png
/usr/share/doc/pgadmin3/en_US/_images/options-macros.png
/usr/share/doc/pgadmin3/en_US/_images/options-properties.png
/usr/share/doc/pgadmin3/en_US/_images/options-query_editor.png
/usr/share/doc/pgadmin3/en_US/_images/options-query_file.png
/usr/share/doc/pgadmin3/en_US/_images/options-results_grid.png
/usr/share/doc/pgadmin3/en_US/_images/options-server_status.png
/usr/share/doc/pgadmin3/en_US/_images/options-ui_miscellaneous.png
/usr/share/doc/pgadmin3/en_US/_images/options-user_interface.png
/usr/share/doc/pgadmin3/en_US/_images/options.png
/usr/share/doc/pgadmin3/en_US/_images/password.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-jobdetails.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-jobproperties.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-jobstats.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-scheduledetails1.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-scheduledetails2.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-scheduledetails3.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-scheduleproperties.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-stepdetails.png
/usr/share/doc/pgadmin3/en_US/_images/pgagent-stepstats.png
/usr/share/doc/pgadmin3/en_US/_images/query-analyze.png
/usr/share/doc/pgadmin3/en_US/_images/query-connect.png
/usr/share/doc/pgadmin3/en_US/_images/query.png
/usr/share/doc/pgadmin3/en_US/_images/reporttool-html.png
/usr/share/doc/pgadmin3/en_US/_images/reporttool-xml.png
/usr/share/doc/pgadmin3/en_US/_images/restore-2.png
/usr/share/doc/pgadmin3/en_US/_images/restore-3.png
/usr/share/doc/pgadmin3/en_US/_images/restore-4.png
/usr/share/doc/pgadmin3/en_US/_images/restore-5.png
/usr/share/doc/pgadmin3/en_US/_images/restore.png
/usr/share/doc/pgadmin3/en_US/_images/search.png
/usr/share/doc/pgadmin3/en_US/_images/server.png
/usr/share/doc/pgadmin3/en_US/_images/slony-create.png
/usr/share/doc/pgadmin3/en_US/_images/slony-execute.png
/usr/share/doc/pgadmin3/en_US/_images/slony-join.png
/usr/share/doc/pgadmin3/en_US/_images/slony-listen.png
/usr/share/doc/pgadmin3/en_US/_images/slony-overview.png
/usr/share/doc/pgadmin3/en_US/_images/slony-path.png
/usr/share/doc/pgadmin3/en_US/_images/slony-sequence.png
/usr/share/doc/pgadmin3/en_US/_images/slony-set.png
/usr/share/doc/pgadmin3/en_US/_images/slony-subscription.png
/usr/share/doc/pgadmin3/en_US/_images/slony-table.png
/usr/share/doc/pgadmin3/en_US/_images/slony-upgrade.png
/usr/share/doc/pgadmin3/en_US/_images/status.png
/usr/share/doc/pgadmin3/en_US/_static
/usr/share/doc/pgadmin3/en_US/_static/backup-2.png
/usr/share/doc/pgadmin3/en_US/_static/backup-3.png
/usr/share/doc/pgadmin3/en_US/_static/backup-4.png
/usr/share/doc/pgadmin3/en_US/_static/backup-5.png
/usr/share/doc/pgadmin3/en_US/_static/backup.png
/usr/share/doc/pgadmin3/en_US/_static/basic.css
/usr/share/doc/pgadmin3/en_US/_static/classic.css
/usr/share/doc/pgadmin3/en_US/_static/connect.png
/usr/share/doc/pgadmin3/en_US/_static/debugger.png
/usr/share/doc/pgadmin3/en_US/_static/default.css
/usr/share/doc/pgadmin3/en_US/_static/doctools.js
/usr/share/doc/pgadmin3/en_US/_static/documentation_options.js
/usr/share/doc/pgadmin3/en_US/_static/editgrid.png
/usr/share/doc/pgadmin3/en_US/_static/export.png
/usr/share/doc/pgadmin3/en_US/_static/file.png
/usr/share/doc/pgadmin3/en_US/_static/gqb.png
/usr/share/doc/pgadmin3/en_US/_static/grantwiz.png
/usr/share/doc/pgadmin3/en_US/_static/gridopt-filter.png
/usr/share/doc/pgadmin3/en_US/_static/gridopt-sort.png
/usr/share/doc/pgadmin3/en_US/_static/guru-connect.png
/usr/share/doc/pgadmin3/en_US/_static/jquery-3.5.1.js
/usr/share/doc/pgadmin3/en_US/_static/jquery.js
/usr/share/doc/pgadmin3/en_US/_static/language_data.js
/usr/share/doc/pgadmin3/en_US/_static/locks.png
/usr/share/doc/pgadmin3/en_US/_static/logfile.png
/usr/share/doc/pgadmin3/en_US/_static/main.png
/usr/share/doc/pgadmin3/en_US/_static/maintenance.png
/usr/share/doc/pgadmin3/en_US/_static/manage-macros.png
/usr/share/doc/pgadmin3/en_US/_static/minus.png
/usr/share/doc/pgadmin3/en_US/_static/no-hba.png
/usr/share/doc/pgadmin3/en_US/_static/not-running.png
/usr/share/doc/pgadmin3/en_US/_static/options-binary_paths.png
/usr/share/doc/pgadmin3/en_US/_static/options-colours.png
/usr/share/doc/pgadmin3/en_US/_static/options-database_designer.png
/usr/share/doc/pgadmin3/en_US/_static/options-display.png
/usr/share/doc/pgadmin3/en_US/_static/options-favourites.png
/usr/share/doc/pgadmin3/en_US/_static/options-guru_hints.png
/usr/share/doc/pgadmin3/en_US/_static/options-help_paths.png
/usr/share/doc/pgadmin3/en_US/_static/options-history_file.png
/usr/share/doc/pgadmin3/en_US/_static/options-logging.png
/usr/share/doc/pgadmin3/en_US/_static/options-macros.png
/usr/share/doc/pgadmin3/en_US/_static/options-properties.png
/usr/share/doc/pgadmin3/en_US/_static/options-query_editor.png
/usr/share/doc/pgadmin3/en_US/_static/options-query_file.png
/usr/share/doc/pgadmin3/en_US/_static/options-results_grid.png
/usr/share/doc/pgadmin3/en_US/_static/options-server_status.png
/usr/share/doc/pgadmin3/en_US/_static/options-ui_miscellaneous.png
/usr/share/doc/pgadmin3/en_US/_static/options-user_interface.png
/usr/share/doc/pgadmin3/en_US/_static/options.png
/usr/share/doc/pgadmin3/en_US/_static/password.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-jobdetails.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-jobproperties.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-jobstats.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-scheduledetails1.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-scheduledetails2.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-scheduledetails3.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-scheduleproperties.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-stepdetails.png
/usr/share/doc/pgadmin3/en_US/_static/pgagent-stepstats.png
/usr/share/doc/pgadmin3/en_US/_static/plus.png
/usr/share/doc/pgadmin3/en_US/_static/pygments.css
/usr/share/doc/pgadmin3/en_US/_static/query-analyze.png
/usr/share/doc/pgadmin3/en_US/_static/query-connect.png
/usr/share/doc/pgadmin3/en_US/_static/query.png
/usr/share/doc/pgadmin3/en_US/_static/reporttool-html.png
/usr/share/doc/pgadmin3/en_US/_static/reporttool-xml.png
/usr/share/doc/pgadmin3/en_US/_static/restore-2.png
/usr/share/doc/pgadmin3/en_US/_static/restore-3.png
/usr/share/doc/pgadmin3/en_US/_static/restore-4.png
/usr/share/doc/pgadmin3/en_US/_static/restore-5.png
/usr/share/doc/pgadmin3/en_US/_static/restore.png
/usr/share/doc/pgadmin3/en_US/_static/search.png
/usr/share/doc/pgadmin3/en_US/_static/searchtools.js
/usr/share/doc/pgadmin3/en_US/_static/server.png
/usr/share/doc/pgadmin3/en_US/_static/sidebar.js
/usr/share/doc/pgadmin3/en_US/_static/slony-create.png
/usr/share/doc/pgadmin3/en_US/_static/slony-execute.png
/usr/share/doc/pgadmin3/en_US/_static/slony-join.png
/usr/share/doc/pgadmin3/en_US/_static/slony-listen.png
/usr/share/doc/pgadmin3/en_US/_static/slony-overview.png
/usr/share/doc/pgadmin3/en_US/_static/slony-path.png
/usr/share/doc/pgadmin3/en_US/_static/slony-sequence.png
/usr/share/doc/pgadmin3/en_US/_static/slony-set.png
/usr/share/doc/pgadmin3/en_US/_static/slony-subscription.png
/usr/share/doc/pgadmin3/en_US/_static/slony-table.png
/usr/share/doc/pgadmin3/en_US/_static/slony-upgrade.png
/usr/share/doc/pgadmin3/en_US/_static/status.png
/usr/share/doc/pgadmin3/en_US/_static/transaction.png
/usr/share/doc/pgadmin3/en_US/_static/underscore-1.3.1.js
/usr/share/doc/pgadmin3/en_US/_static/underscore.js
/usr/share/doc/pgadmin3/en_US/appendices.html
/usr/share/doc/pgadmin3/en_US/backup.html
/usr/share/doc/pgadmin3/en_US/bugreport.html
/usr/share/doc/pgadmin3/en_US/commandline.html
/usr/share/doc/pgadmin3/en_US/connect-error.html
/usr/share/doc/pgadmin3/en_US/connect.html
/usr/share/doc/pgadmin3/en_US/control-server.html
/usr/share/doc/pgadmin3/en_US/debugger.html
/usr/share/doc/pgadmin3/en_US/default-xsl.html
/usr/share/doc/pgadmin3/en_US/editgrid.html
/usr/share/doc/pgadmin3/en_US/export.html
/usr/share/doc/pgadmin3/en_US/extend.html
/usr/share/doc/pgadmin3/en_US/genindex.html
/usr/share/doc/pgadmin3/en_US/gqb.html
/usr/share/doc/pgadmin3/en_US/grantwiz.html
/usr/share/doc/pgadmin3/en_US/gridopts.html
/usr/share/doc/pgadmin3/en_US/guruhints.html
/usr/share/doc/pgadmin3/en_US/index.html
/usr/share/doc/pgadmin3/en_US/introduction.html
/usr/share/doc/pgadmin3/en_US/kerberos.html
/usr/share/doc/pgadmin3/en_US/licence.html
/usr/share/doc/pgadmin3/en_US/macros.html
/usr/share/doc/pgadmin3/en_US/main.html
/usr/share/doc/pgadmin3/en_US/maintenance.html
/usr/share/doc/pgadmin3/en_US/openssl.html
/usr/share/doc/pgadmin3/en_US/options-browser.html
/usr/share/doc/pgadmin3/en_US/options-database_designer.html
/usr/share/doc/pgadmin3/en_US/options-miscellaneous.html
/usr/share/doc/pgadmin3/en_US/options-query_tool.html
/usr/share/doc/pgadmin3/en_US/options-server_status.html
/usr/share/doc/pgadmin3/en_US/options.html
/usr/share/doc/pgadmin3/en_US/password.html
/usr/share/doc/pgadmin3/en_US/pgadmin3.hhc
/usr/share/doc/pgadmin3/en_US/pgadmin3.hhk
/usr/share/doc/pgadmin3/en_US/pgadmin3.hhp
/usr/share/doc/pgadmin3/en_US/pgadmin3.stp
/usr/share/doc/pgadmin3/en_US/pgagent-install.html
/usr/share/doc/pgadmin3/en_US/pgagent-jobs.html
/usr/share/doc/pgadmin3/en_US/pgagent-schedules.html
/usr/share/doc/pgadmin3/en_US/pgagent-steps.html
/usr/share/doc/pgadmin3/en_US/pgagent.html
/usr/share/doc/pgadmin3/en_US/pgscript.html
/usr/share/doc/pgadmin3/en_US/query.html
/usr/share/doc/pgadmin3/en_US/reports.html
/usr/share/doc/pgadmin3/en_US/restore.html
/usr/share/doc/pgadmin3/en_US/sample-xml.html
/usr/share/doc/pgadmin3/en_US/search_object.html
/usr/share/doc/pgadmin3/en_US/slony-example.html
/usr/share/doc/pgadmin3/en_US/slony-execute.html
/usr/share/doc/pgadmin3/en_US/slony-functions.html
/usr/share/doc/pgadmin3/en_US/slony-install.html
/usr/share/doc/pgadmin3/en_US/slony-overview.html
/usr/share/doc/pgadmin3/en_US/slony-path.html
/usr/share/doc/pgadmin3/en_US/slony-set.html
/usr/share/doc/pgadmin3/en_US/slony.html
/usr/share/doc/pgadmin3/en_US/status.html
/usr/share/doc/pgadmin3/en_US/team.html
/usr/share/doc/pgadmin3/en_US/translation_team.html
/usr/share/doc/pgadmin3/en_US/using.html
/usr/share/icons/hicolor/128x128/apps/pgAdmin3.png
/usr/share/icons/hicolor/16x16/apps/pgAdmin3.png
/usr/share/icons/hicolor/22x22/apps/pgAdmin3.png
/usr/share/icons/hicolor/24x24/apps/pgAdmin3.png
/usr/share/icons/hicolor/256x256/apps/pgAdmin3.png
/usr/share/icons/hicolor/32x32/apps/pgAdmin3.png
/usr/share/icons/hicolor/36x36/apps/pgAdmin3.png
/usr/share/icons/hicolor/48x48/apps/pgAdmin3.png
/usr/share/icons/hicolor/96x96/apps/pgAdmin3.png
/usr/share/licenses/pgadmin3
/usr/share/licenses/pgadmin3/LICENSE
/usr/share/locale/ca_ES/pgadmin3.mo
/usr/share/locale/cs_CZ/pgadmin3.mo
/usr/share/locale/de_DE/pgadmin3.mo
/usr/share/locale/fr_FR/pgadmin3.mo
/usr/share/locale/ja_JP/pgadmin3.mo
/usr/share/locale/lv_LV/pgadmin3.mo
/usr/share/locale/pl_PL/pgadmin3.mo
/usr/share/locale/ru_RU/pgadmin3.mo
/usr/share/locale/sr_RS/pgadmin3.mo
/usr/share/locale/zh_CN/pgadmin3.mo
/usr/share/metainfo/org.postgresql.pgadmin3.appdata.xml
/usr/share/pgadmin3
/usr/share/pgadmin3/branding
/usr/share/pgadmin3/branding/branding.ini
/usr/share/pgadmin3/i18n
/usr/share/pgadmin3/i18n/pg_settings.csv
/usr/share/pgadmin3/i18n/pgadmin3.lng
/usr/share/pgadmin3/plugins.d
/usr/share/pgadmin3/plugins.d/plugins.ini
/usr/share/pgadmin3/settings.ini

References

Summary

In this tutorial we learn how to install pgadmin3 on Fedora 34 using yum and dnf.