Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»Databases»PostgreSQL»How To Install PostgreSQL and pgAdmin4 in Fedora 35/34

    How To Install PostgreSQL and pgAdmin4 in Fedora 35/34

    By RahulApril 18, 20225 Mins Read

    PostgreSQL is an open-source object-relational, highly scalable, SQL-compliant database management system. It is developed at the University of California at Berkeley’s Computer Science Department. At the time of the last update of this article, PostgreSQL 13 is the latest stable version available for production servers. PostgreSQL 14 is under the development mode and not suggested for production users.

    Advertisement

    pgAdmin4 is a client application used for managing PostgreSQL servers graphically. It is available as a desktop application for Linux desktop systems as well as a web application. Which provides a beautiful and easy-to-use web interface and helps us to increase productivity.

    This article will help you to install the PostgreSQL server on Fedora 34/33 Linux system. Also, provide you the instructions to install pgAdmin4 on the Fedora system. This article has been tested with the Fedora version 34.

    Step 1 – Installing PostgreSQL on Fedora

    Follow the below instructions to install the PostgreSQL server on a Fedora system.

    1. First of all, search for the available DNF modules contains the PostgreSQL server packages. Open a terminal and type the below command:

    sudo dnf module list postgresql 
    

    DNF search for PostgrSQL repositories

    2. In the above command, you will see the available PostgreSQL versions. Now enable the repository of the required version. The below command will enable the repository for the PostgreSQL 13 on your system.

    sudo dnf module enable postgresql:13 
    

    Enable PostgreSQL Repository with DNF

    3. Once you have successfully enabled the required DNF module. Use the following command to install the PostgreSQL server packages using DNF package manager. This will also install additional required packages on your system.

    sudo dnf install postgresql-server 
    

    Press ‘y’ to confirm and finish the packages installation.

    4. After that, you need to initialize the PostgreSQL data directory. In other words, this will create a data directory and other configuration files on your system.

    To initialize the database server, type:

    sudo postgresql-setup --initdb 
    

    Initialize PostgreSQL environment on Fedora

    After finishing the above command, the PostgreSQL server installation is completed on your Fedora system. PostgreSQL server uses PGDATA environment variable to contain the data directory location.

    Setp 2 – Manage PostgreSQL Service

    To start the PostgreSQL service use the following command as per your operating systems. Also, enable the PostgreSQL service to autostart on system boot.

    sudo systemctl enable postgresql 
    sudo systemctl start postgresql 
    

    You can see the current status of the service using the following command.

    sudo systemctl status postgresql 
    

    Managing PostgreSQL service on Fedora

    Step 3 – Secure Postgres User

    After completing the above steps. Your PostgreSQL 11 server is ready to use. Log in to the postfix instance to verify the connection.

    su - postgres -c "psql" 
    

    You may create a strong password for the “postgres” account to enhance server security.

    postgres=# \password postgres
    

    Create password for "postgres" default account

    Step 4 – Installing pgAdmin4 on Fedora

    The pgAdmin4 is a great tool for managing PostgreSQL server databases with a graphical interface. It is available as an application for desktop systems. Also, a web version is available to access in a web browser. The below steps will help you to set pgAdmin4 on your Fedora system.

    1. First, configure the pgAdmin4 repository to your Fedora system. In a terminal execute the following command.

    sudo rpm -Uvh https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-fedora-repo-2-1.noarch.rpm 
    

    2. After that, install the pgadmin4-web package on your system. This will also add other dependencies to your system.

    sudo dnf install pgadmin4-web 
    

    Installing pgAdmin web interface on Fedora

    3. The policycoreutils-python-utils package contains the management tools use to manage an SELinux environment for the Python applications. Install it on your system with the following command.

    sudo dnf install policycoreutils-python-utils 
    

    4. Finally, run a shell script to configure the pgAdmin4 on your system. This will prompt for an email address and password to enable web application authentication.

    sudo /usr/pgadmin4/bin/setup-web.sh 
    

    Configure pgAdmin Environment on Fedora

    Remember that, this authentication is just for login to the pgAdmin4 dashboard. It can’t be used to log in to the PostgreSQL server.

    Step 5 – Allow Public Access to pgAdmin4

    The Fedora systems use a firewall to protect the server from external users. You need to allow access on port 80 to access pgAdmin4 from outside of the server.

    To open web port in firewall, type:

    sudo firewall-cmd --add-port=80/tcp --permanent 
    sudo firewall-cmd --reload 
    

    As the Fedora system has default SELinux in enforcing mode, you need to apply SELinux setting to allow network access to the webserver.

    sudo setsebool -P httpd_can_network_connect 1 
    

    In the end, restart the Apache service to reload all the settings and changes.

    sudo systemctl restart httpd 
    

    Step 6 – Access pgAdmin4

    Now, you can access the pgAdmin4 web application in a web browser. Access your server with the IP address following with /pgadmin4

    http(s)://server-ip/pgadmin4

    Login to pgAdmin on Fedora

    Enter login credentials created in the above step. After a successful login, you will get access to the pgAdmin4 dashboard. Here you can connect multiple PostgreSQL servers and manage them.

    pgAdmin Dashboard on Fedora

    Conclusion

    In conclusion, You have successfully installed the PostgreSQL server on the Fedora Linux system. Additionally, provides you instructions to install the pgAdmin4 dashboard to manage the PostgreSQL server graphically.

    fedora pgadmin4 postgres PostgreSQL psql
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    How to Install Postgres on MacOS

    How To Install PostgreSQL on MacOS

    How To Install Apache Solr on Fedora

    How To Install Apache Solr 9.0 on Fedora 36/35

    How to Install Git on Fedora Linux

    How To Install Git on Fedora Linux

    View 6 Comments

    6 Comments

    1. Gilbert on January 19, 2022 7:12 am

      I’ve been looking for this article…was truly helpful for me

      Reply
    2. Marco on August 16, 2021 3:16 pm

      Thanks!, this article is excellent

      Reply
    3. harry on August 7, 2021 5:47 pm

      Thanks, this article is perfectly.

      Reply
    4. Drew Jaqua on July 27, 2019 5:27 am

      This was a flawless how-to. Thank you.

      Reply
    5. mike lancaster on May 21, 2019 9:58 pm

      Thanks!

      Reply
    6. derek on May 12, 2019 7:13 pm

      Working perfectly

      Reply

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • Implementing a Linux Server Security Audit: Best Practices and Tools
    • cp Command in Linux (Copy Files Like a Pro)
    • 15 Practical Examples of dd Command in Linux
    • dd Command in Linux (Syntax, Options and Use Cases)
    • Iptables: Common Firewall Rules and Commands
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.