To change the database admin user password, first switch to postgres user, # systemctl enable postgresql-11 PostgreSQL configuration Now we will start the database service & also enable it to start at boot time, # /usr/pgsql-11/bin/postgresql-11-setup initdb # yum install postgresql11-server postgresql11

Next, we can run the yum install command to install postgresql, Using this method, we will install a stable version 11 of PostgreSQL Install the official repository with the following command, So to install the desired version we must use the second method.Ģ- Install Postgresql using Official Postgresql repositories The only downside to installing postgresql using this method is that we might not get the latest version as the default Centos or RHEL repositories don’t always maintain the latest versions.

So our database is now up & ready to be used.

Now we can start the database & also enable it to start at boot time, Once the database has been started, we need to initialize the database before we can start using it, # yum install postgresql-server postgresql-contrib This method is quite simple, we can just run the following command to install postgresql on the server, There are two methods using which we can install Postgresql on CentOS/RHEL systems,ġ- Using the default CentOS repositories,Ģ- Using the official PostgreSQL repositoriesġ- Install Postgresql using default repositories In this tutorial, we will learn to install PostgreSQL on CentOS & RHEL systems. Recommended Read: How to setup SSH login without password It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It has a strong reputation for reliability, performance & is feature robust. PostgreSQL (also called postgres) is a very famous, powerful, open-source relational database system that has been around for almost 30 years.

Postgresql centos 7 install