![install postgresql on centos 8 featured](https://manjaro.site/wp-content/uploads/2020/01/install-postgresql-on-centos-8-featured.jpg)
Welcome to CentOS Tutorial. In this article, we are going to install the PostgreSQL 10 on CentOS 8. PostgreSQL is a popular RDBMS available for free. Installing PostgreSQL is not difficult. With a few commands, we can get PostgreSQL Server up and running within minutes. There are personal reasons why I prefer PostgreSQL rather than other RDBMS server such as MySQL or MariaDB.
Steps to Install PostgreSQL 10 on CentOS 8
First, let’s check the availability of the PostgreSQL package in CentOS repository. Please execute these commands below as root user.
dnf module list postgresql
Output
![](https://manjaro.site/wp-content/uploads/2020/01/check-postgresql.jpg)
As you can see there are two PostgreSQL versions available from the repository. In this case, we are going to install version 10. To do this, use this command
dnf install @postgresql:10
Output
![](https://manjaro.site/wp-content/uploads/2020/01/install-postgres-centos-8.jpg)
Or basically, because PostgreSQL 10 is the default package, you can just use this command to install
dnf install postgresql
![](https://manjaro.site/wp-content/uploads/2020/01/install-postgres-centos-8-2.jpg)
Additionally, you may also need to install the following package
dnf install postgresql-contrib
Once the installation completes, continue with this command to initialize the database.
postgresql-setup initdb
Now start the service and enable during startup
systemctl start postgresql
systemctl enable postgresql
Make sure you see the service is active
![](https://manjaro.site/wp-content/uploads/2020/01/postgresql-status.jpg)
Change the postgres password
By default, postgres user does not have password. We can change the password with this command
Login as postgres user and then execute psql command:
su - postgres
psql
ALTER USER postgres WITH PASSWORD '12345';
Enable Remote Connection to PostgreSQL Server
In order to enable remote connection to the server, we need to edit the following files:
- postgresql.con
- pg_hba.conf
su
nano nano /var/lib/pgsql/data/postgresql.conf
Edit the value of listen_addresses = ‘localhost‘ to ‘*’ as follow:
- Connection Settings - listen_addresses = '*' # what IP address(es) to listen on;
Next, edit the pg_hba.conf
su
nano /var/lib/pgsql/data/pg_hba.conf
add the following line to the end of the file
host all all 0.0.0.0/0 md5
Restart PostgreSQL service
su
systemctl restart postgresql
Done. Now try to connect to the server from other computer. In this case, I use Navicat Premium to connect to the server from a Windows 10 PC.
![](https://manjaro.site/wp-content/uploads/2020/01/postgresql-navicat.jpg)
![](https://manjaro.site/wp-content/uploads/2020/01/navicat-postgresql.jpg)
Thank you for reading this article, I hope you enjoy it. Cheers.
Leave a Reply