Installing PostgreSQL 14 on CentOS 7

PostgreSQL 14 has few improvements over previous versions, especially older ones, like 9.6. This includes automatic data direction using partitioning. So, let’s install it on CentOS 7.

yum -y install
yum install -y postgresql14-server postgresql14
/usr/pgsql-14/bin/postgresql-14-setup initdb
systemctl enable postgresql-14
service postgresql-14 start

Then you should login to the database and set password:

sudo -u postgres -i

Basic configuration includes firewall setup (if it’s active), access control and performance settings:


I strongly recommend visiting for tuning parameters. Last thing is to set interface address on which server will be listening, it’s set in:


Now you are good to go.