To enable the PostgreSQL repository simply install the repository rpm file: sudo yum install Page and check if there is a new version available.įollow the steps below to install the latest PostgreSQL version on your CentOS server : Before continuing with the next step you should visit the PostgreSQL Yum Repository Install PostgreSQL from the PostgreSQL repositories #Īt the time of writing this article, the latest version of PostgreSQL available from the official PostgreSQL repositories is PostgreSQL version 10.4. Psql is an interactive command line utility that allows us to interact with the PostgreSQL server. To verify the installation we will try to connect to the PostgreSQL database server using the psql tool and print the server version

To start the PostgreSQL service and enable it to start on boot simply type: sudo systemctl start postgresql sudo systemctl enable postgresql Initialize the PostgreSQL database with the following command: sudo postgresql-setup initdb Initializing database. To install the PostgreSQL server along with the PostgreSQL contrib package which provides several additional features for the PostgreSQL database simply type: sudo yum install postgresql-server postgresql-contrib To install PostgreSQL on your CentOS server follow the steps below: Install PostgreSQL from the CentOS repositories #Īt the time of writing this article, the latest version of PostgreSQL available from the CentOS repositories is PostgreSQL version 9.2.23. Prerequisites #īefore continuing with this tutorial, make sure you are logged in as a user with sudo privileges We will also explore the fundamentals of PostgreSQL database administration. If your application doesn’t require the latest version, we recommend using the first method and install PostgreSQL from the CentOS repositories. The first method will walk you through the steps necessary to install PostgreSQL v9.2.23 from the CentOS repositories while the second one will show you how to install the latest version of PostgreSQL from the official PostgreSQL repositories. In this tutorial, we will show you two different methods on how to install PostgreSQL on your CentOS 7 machine.

Install postgresql centos 7