PostgreSQL, also known as Postgres, is an open source relational database management system (RDBMS) that implements Structured Query Language (SQL). PostgreSQL is an enterprise-class SQL database server that allows you to build fault-tolerant and complex applications. It stores and organizes data and allows you to structurally retrieve information. PostgreSQL has many advanced features such as reliable transactions and high concurrency. In this tutorial, we will learn how to install PostgreSQL on CentOS8. So let’s get started.
Installing PostgreSQL on CentOS
There are different PostgreSQL versions in the CentOS 8 repository that you can install. To list the available streams for PostgreSQL, open a terminal and use the following command:
# dnf module list postgresql
PostgreSQL App Stream version 10 is enabled by default, to install the latest postgresql App Stream which is Stream12 you need to enable its repository using the following command, you can enable PostgreSQL Stream 12:
# dnf module enable postgresql:12
After enabling the latest version of PostgreSQL 12. Now we can install PostgreSQL using the following command:
# dnf install postgresql-server
With the software now installed, you need to complete some initial steps to prepare and configure your new database cluster by using the following command:
# dnf install postgresql-initdb
After initialization, start and enable the PostgreSQL service using the following command:
# systemctl enable postgresql # systemctl start postgresql
After turn on and Start service, check the status of the service by running the following command shown below:
# systemctl status postgresql
The above screenshot shows the service is running.
Enable remote access to PostgreSQL server
By default the PostgreSQL server only listens on the local interface, to enable PostgreSQL for remote access, open the config file postgresql.conf by typing the following command:
# vim /var/lib/pgsql/data/postgresql.conf
Scroll down to Connections and Authentication section and edit the following line by uncommenting:
This will also provide access for remote users. Save and close the configuration file and restart the PostgreSQL service by entering the following command:
# systemctl restart postgresql
You can also make sure PostgreSQL access is allowed for all users using the following command:
# netstat –atnp | grep 5432
The above output shows the PostgreSQL server is running on default ports on all interfaces.
Configure PostgreSQL Firewall
PostgreSQL uses port 5432 to connect. To allow PostgreSQL from the firewall for remote access, use the following command:
# firewall-cmd –add-port=5432/tcp –permanent # firewall-cmd –reload
The final steps are to allow the server to accept remote connections for this edit “pg_hba.conf“configuration file. The file is located”/ var / library / pgsql / data /“Catalog.
In this tutorial, we learned how to install PostgreSQL on CentOS 8. We also saw how to allow PostgreSQL for dial-up connections, how to add a firewall rule to allow remote access. I hope this tutorial helps you set up PostgreSQL on Centos 8.
How to Install PostgreSQL Database Server CentOS 8