How to Install PostgreSQL 13 on CentOS 8
In this tutorial, we'll walk you through the installation and initial configuration of PostgreSQL 13 on CentOS 8. Updates for PostgreSQL 13 will be released for five years through November 2025. You must run all commands as root.
In the Serverspace you can create a server with already installed app "PostgreSQL".
Installing PostgreSQL 13 packages
Add PostgreSQL repository to the system.
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpmTurn off the PostgreSQL modules with an older version present in the system.
dnf -qy module disable postgresqlLet’s install PostgreSQL 13 server.
dnf install -y postgresql13-serverInitial configuration
Initialize the database.
/usr/pgsql-13/bin/postgresql-13-setup initdb
Initializing database ... OKStart and enable autostart of the PostgreSQL service.
systemctl enable --now postgresql-13Set a password for the postgres user.
su - postgres
psql -c "alter user postgres with password 'psql-user-pass'"
ALTER ROLE
exit
logoutCreating a new PostgreSQL user
To create a new user in PostgreSQL, you first need to create it in the system itself.
adduser username
passwd usernameLog in as postgres.
su - postgresCreate a database user.
createuser usernameCreate a database for this user.
createdb usernameThe new user can now work with PostgreSQL. Let’s log in. Enter username’s password when prompted.
su - username
Password:Enter the PostgreSQL command line.
psql
psql (13.1)
Type "help" for help.
username=>
700
300
700
300
700
300
700
300
