The pgAdmin is a feature-rich web-based interface for the administration, development, and management of PostgreSQL. It is also an open-source, free software just like PostgreSQL. In this how-to guide we will learn to install PostgreSQL and pgAdmin4 on CentOS 8:
How to Install PostgreSQL on CentOS 8
Multiple versions of PostgreSQL are available in a default repository of CentOS 8. They can be listed on the terminal by using the below-given command: There are four different versions available in the AppStream repository on my system. The [d] after the PostgreSQL version 10 indicates that version 10 is the default version of PostgreSQL.
By default it will install PostgreSQL 10 on your system. We can install any other version on our CentOS 8 system as well. To install any other version we will first need to reset the already installed module stream:
Now we will enable the module stream of the latest PostgreSQL version:
Now run the installation command again. The terminal will now install the latest version i.e. version 13:
You can verify the installed version by using the below-given command:
Now that the latest version of PostgreSQL has been installed, initialize it by using the below-given command:
You can start the database by running the command:
The PostgreSQL can also be enabled to automatically start at the boot:
You can check the status of the service by using this command:
You can also check whether the service has been successfully enabled to start at the boot:
How to Install pgAdmin4 in CentOS 8
- Now we will install pgAdmin4, the web-based PostgreSQL database management tool. To install pgAdmin4 we first need to install the EPEL repository:
- Next, we will install a pgAdmin repository to resolve the dependencies:
- In order to install the pgAdmin4 on our system we will also need to remove some PostgreSQL repositories: This repository has already been uninstalled from my system.
- Now we will make a cache for pgAdmin4 by executing the below-given command:
- We can finally install pgAdmin4 on our system as all the dependencies have been resolved:
Press y and hit Enter whenever prompted to do so: The pgAdmin4 has been successfully installed on the system. 06. The next step is to set up pgAdmin4. This can be done by opening the configuration file that comes with the pgAdmin4 package:
- The configuration script will ask you for an email and a password to create a new user account for the web interface. You can now access pgAdmin4 by navigating to the following address on your browser: For the remote systems, change “localhost” with the remote server IP address or domain name.
Conclusion
The latest versions of PostgreSQL and pgAdmin4 have been successfully installed on your system. Now you can configure them according to your requirements. PostgreSQL is a powerful RDBMS; It is open-source and runs across platforms and is known for its reliability and robust features. RDBMS helps store, organize, and access data in a structured manner. pgAdmin4 is a GUI-based web application that is used for the management of the PostgreSQL databases. In this installation guide, we have learned to install PostgreSQL and pgAdmin4 on our CentOS 8 system.
