How to Install PostgreSQL on CentOS 7

In this article, we will have explained the necessary steps to install and configure PostgreSQL on CentOS 7. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.

PostgreSQL PostgreSQL is a powerful and open source relational database platform. It’s scalable across multiple platforms and is a widely used and well-loved tool.

Install PostgreSQL on CentOS 7

Step 1. The first command will update the package lists to ensure you get the latest version and dependencies.

Step 2. Install PostgreSQL.

Now run following command to install PostgreSQL with -contrib package which adds additional features and functionalities to PostgreSQL:

Once the installation is done, you can initialize the database using the below command:

To start and enable PostgreSQL service after boot run following commands:

Step 4. Create PostgreSQL Database and Role.

• Create a new PostgreSQL RoleThe following command will create a new role named ramona:
  1	<spanclass="line">sudosu-postgres-c"createuser meilanamaria"</span>

• Create a new PostgreSQL DatabaseCreate a new database named ramona using the createdb command:
  1	<spanclass="line">sudosu-postgres-c"createdb meilanamariadb"</span>

• Grant privilegesTo grant permissions to the ramona user on the database we created in the previous step, connect to the PostgreSQL shell:
  1	<spanclass="line">sudo-upostgrespsql</span>

  and run the following query:

  1

  <spanclass="k">grant</span><spanclass="k">all</span><spanclass="k">privileges</span><spanclass="k">on</span><spanclass="k">database</span><codeclass="language-console-bash"data-lang="console-bash"><spanclass="line">meilanamaria</span></code>db<spanclass="k">to</span><spanclass="p"><codeclass="language-console-bash"data-lang="console-bash"><spanclass="line">meilanamaria</span></code>;</span>

Step 5. Enable remote access to PostgreSQL server.

Use the following steps to enable remote access to the PostgreSQL server:

Update listen_addresses like given below:

Now restart the PostgreSQL service with systemctl command:

Verify the changes with the ss utility:

Finally update pg_hba.conf file to configure server remote connections using below examples:

Congratulation, you have learned how to install and configure PostgreSQL on CentOS 7. If you have any question, please leave a comment below.