Inside the /var/lib/pgsql/13/data directory, the /base/ directory is where all of our databases will actually be stored.This guide is written for a non-root user. The /var/lib/pgsql/13/data/nf is the main configuration file of the CentOS 8 PostgreSQl 13 cluster. PostgreSQl 13 was installed to /var/lib/pgsql/13 directory. The postgres user can log in to the Postgres shell using the psql command without a password. The postgres user does not have a password, hence you need to log in to the user account using root privileges as follows: su - postgres This Linux user is the superuser of the Postgres Cluster. You can run the following command to get a list of all available versions: dnf search postgresql | grep -i server Getting to Know Your ClusterĪ new Linux user called postgres was created during the installation.

There are a couple of different versions of PostgreSQL available. To install PostgreSQL 13, we executed the following command: sudo dnf install -y postgresql13-server Next, we installed the DNF Repository by running the following command: sudo dnf install -y We started by disabling the default PostgreSQL package: sudo dnf -qy module disable postgresql To get the latest version, we need to set up PostgreSQL DNF Repository. Sudo systemctl start postgresql-13 How it Works…Ī version of PostgreSQL ships with CentOS default software repository.

Now run the following to start and enable CentOS postgresql service: sudo /usr/pgsql-13/bin/postgresql-13-setup initdb You have successfully installed PostgreSQL on your CentOS computer. PostgreSQL 13 is the latest version, which you can install on CentOS by running the following set commands as root at the command prompt: sudo dnf -qy module disable postgresql In this tutorial, we will learn how to install PostgreSQL on CentOS 8/ RHEL 8.

Install postgresql centos 8