Advance

Tutorial Install pgAdmin 4 On Fedora 33

Tutorial Install pgAdmin 4 On Fedora 33

pgAdmin is the most popular, free, and open-source management tool for PostgreSQL. pgAdmin is a feature-rich PostgreSQL administration and development platform. It can be installed on multiple OS platforms such as Linux, Unix, Mac OS X, and Windows. pgAdmin can also be run as a web or desktop application. database developers exactly understand the importance of a tool to manage databases. This article presents the Tutorial Install pgAdmin 4 On Fedora 33. To purchase your own Linux VPS, visit the available packages on Eldernode and choose what you need.

How to Install pgAdmin 4 On Fedora 33 [step by step]

pgAdmin is packed with a rich set of features to manage databases including a simple to use connection wizard, a built-in SQL editor to import SQL scripts. Different types of database operations can be done easily from the browser by using this software. This PostgreSQL administration and development platform can run on Linux, Unix, Mac OS X, and Windows. In the following of this guide, you will know more about pgAdmin and review the pgAdmin 4 installation on Fedora 33.

Recommended Article: How to Install Fedora on VirtualBox

What is pgAdmin 4 and How it works?

pgAdmin is using as a database management tool in the PostgresDB community. A database tool helps you to create schemas, query ad-hoc, backup, or dive deeper to troubleshoot a database issue and finally increases your productivity. pgAdmin offers a clean and intuitive user interface to simplify the creation, maintenance, and use of database objects.

As you read, pgAdmin can be run as a web or desktop application. Server Deployment (web application) and Desktop Deployment (desktop application) are deployment modes of pgAdmin.

Server deployment is deploying as a web application behind a web server running as a reverse proxy or using the WSGI interface.

Desktop deployment is deploying to run in desktop mode by utilizing the desktop runtime to host the application.

pgAdmin Features:

pgAdmin has a huge array of features. Here’s a brief list to give you an idea of its capabilities:

– Multiplatform

– Designed for multiple PostgreSQL versions and derivatives

– Extensive documentation

– Multiple deployment models

– Powerful query tool with color syntax highlighting

– Fast Datagrid for display/entry of data

– Graphical query plan display

– Grant Wizard for rapid updates to ACLs

– Procedural language debugger (supporting pl/pgsql and edb-spl)

– Schema diff tool for managing differences between schemas

– Multibyte support

– Create, view, and edit all common PostgreSQL objects

Prerequisites to Install pgAdmin 4 On Fedora 33

_ A non-root user with Sudo privileges.

_ A PostgreSQL Server installed.

First of all, you must have PostgreSQL installed on your system. If you have not installed it already, here is the process of installing PostgreSQL on Fedora 33. But if PostgreSQL is installed on your system, go to the next section and continue.

Step 1:

To start the installation, as always you should update your system. So, run:

sudo dnf install -y vim bash-completion wget
sudo dnf update -y

You may have Kernel updates, so, you are recommended to reboot your system after an upgrade:

sudo reboot

Step 2:

It is time to add the PostgreSQL Yum Repository to your Fedora system. To do this. use the following command:

sudo dnf install https://download.postgresql.org/pub/repos/yum/reporpms/F-33-x86_64/pgdg-fedora-repo-latest.noarch.rpm

And then, when prompted to confirm installation, press the y key.

Step 3:

Once you added the PostgreSQL Repository to the Fedora system, run the command below to install PostgreSQL 12 Server/Client packages:

sudo dnf install postgresql12-server postgresql12

Step 4:

In this step, you will initialize the database and enable automatic start. So, type:

sudo /usr/pgsql-12/bin/postgresql-12-setup initdb

To start and enable the service to start on boot, run:

sudo systemctl enable --now postgresql-12

Note: If you have a running Firewall service and remote clients should connect to your database server, allow PostgreSQL service.

sudo firewall-cmd --add-service=postgresql --permanent
sudo firewall-cmd --reload

Since you have PostgreSQL installed on your system, you are ready to start the pgAdmin installation process on Fedora 33.

Install pgAdmin 4 On Fedora 33 | Fedora 32

pgAdmin is a free software project released under the PostgreSQL/Artistic license. pgAdmin 4 is a complete rewrite of pgAdmin, built using Python and Javascript/jQuery. Let’s go through the steps of this guide to learn How to Install pgAdmin4 On Fedora 33.

Step 1:

After installing PostgreSQL, you can begin the installation of pgAdmin 4 on Fedora 33. First, you need to add the PostgreSQL RPM repository, which should have been done while installing PostgreSQL:

sudo yum -y install epel-release
sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Next, use the following command to install the pgAdmin package:

sudo yum -y update
sudo yum -y install pgadmin4

Step 2:

Now, to install pgAdmin Fedora, add PostgreSQL Yum Repository to your Fedora 33 system by running the below command:

sudo dnf install https://download.postgresql.org/pub/repos/yum/reporpms/F-33-x86_64/pgdg-fedora-repo-latest.noarch.rpm

After adding the repositories, you can update system packages then install pgadmin4:

sudo dnf -y update && sudo dnf -y install pgadmin4

How to configure pgAdmin 4 on Fedora

Once the pgAdmin 4 is installed on your Fedora 33, you can start configuring it. To start and enable httpd service to start on boot, run:

sudo systemctl start httpd && sudo systemctl enable httpd

Also, you can confirm service status by running:

sudo systemctl status httpd

Now, use the command below to rename the pgAdmin Apache configuration sample:

sudo cp /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf

To confirm configuration syntax to prevent any errors and restart the httpd service, run:

sudo httpd -t
sudo systemctl restart httpd

then use the following command to create pgAdmin data directories:

sudo mkdir -p /var/lib/pgadmin4/ /var/log/pgadmin4/

How to configure SELinux on Fedora 33

For this section, if you have SELinux running in enforcing mode, create and apply a policy to allow Apache users to access pgAdmin directories:

sudo semanage fcontext -a -t httpd_sys_rw_content_t "/var/lib/pgadmin4(/.*)?"
sudo semanage fcontext -a -t httpd_sys_rw_content_t "/var/log/pgadmin4(/.*)?"
sudo restorecon -R /var/lib/pgadmin4/
sudo restorecon -R /var/log/pgadmin4/

Then, use the command below to restart the httpd service:

sudo systemctl restart httpd

How to access pgAdmin 4 Web Interface on fedora 33

If you have an active firewall service, allow http port:

sudo firewall-cmd --permanent --add-service=http
sudo firewall-cmd --reload
Recommended Article: How to Install NTP server on Fedora [New Release]

How to use pgAdmin 4 Web on fedora 33

If you have passed all the above steps correctly, you should now be able to log in to the pgAdmin and start using it. So, open http://pgadmin.example.com/pgadmin4.

Log in to pgAdmin 4 web interface:

 

Install-pgAdmin-4-Login-Screen

 

If you have a successful log-in, the pgAdmin 4 interface will be displayed.

 

pgAdmin 4 Homepage

 

As you see in the Quick Links field, to manage a PostgreSQL server, you need to Add New Server. So, add a PostgreSQL server to administer with pgAdmin. This can be a local or a remote PostgreSQL server. Le’s review the different tabs available on pgAdmin 4 to be able to use and set them correctly.

General Tab:

Name: Name your PostgreSQL Server

 

Add New PostgreSQL Instance on pgAdmin 4

 

Connection Tab:

There, you will see the following fields. Once you made your changes, click on Save.

Hostname/Address: Hostname or IP Address of PostgreSQL server

Port: 5432 (Leave default) – Change it if required

Username: Username by which you are connecting. In my case, it is Postgres.

Password: Password for the user

 

Connection Tab

 

Finally, If the connection to the PostgreSQL server is successful, you should see the following page:

 

Database Statistics

Conclusion

In this article, you learned How To Install pgAdmin 4 On Fedora 33. Then, you reviewed the way you can configure and start using pgAdmin 4 on Fedora 33. Send feedback to your friends on Eldernode Community if you are using pgAdmin or even if you have found a better alternative.

We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

Leave Your Comment

Your email address will not be published.

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+18054214518

7 days a week, 24 hours a day