Guide to Installing PostgreSQL 15 on AlmaLinux 8

In this article,VPTSwill guide you through installing PostgreSQL 15 on AlmaLinux 8 using the official PostgreSQL repository. Content covers system updates, installing PostgreSQL, initializing database clusters, creating users, creating databases, configuring remote access, and opening the firewall securely.

▶

Step 1: Update the system

• To keep your Linux system updated and stable, run the following dnf command to upgrade software packages

Step 2: Enable the official PostgreSQL repository

• PostgreSQL version 15 is not available in AlmaLinux's default repository, so you need to add the official repository:

• Disable the system's default PostgreSQL

Step 3: Install PostgreSQL 15

Install PostgreSQL 15 and server components using the command:

Step 4: Initialize database cluster

After installation, PostgreSQL does not yet have a database cluster to store data. You need to initialize it with the command:

Step 5: Then restart the service

• When the command runs successfully, a message will appearCreated symlink along with the file path.

• Check status:

• If you see:Active: active (running) → PostgreSQL is running properly.

Step 6: Configure PostgreSQL for remote access

Update n8n when installed via npm (Node.js)

• To edit text, go toNew SFTP windowand navigate to the file /var/lib/pgsql/15/data/postgresql.conf to edit the text configuration file
• Update the section: *listen_addresses = '' **as shown below and Save

• After modifying the configuration file, you need to restart the PostgreSQL service to apply the new settings and enable auto-start.

Step 7: Set PostgreSQL user password

• Set a password for the default PostgreSQL user (postgres).

Step 8: Access PostgreSQL Database

• Once a password has been set for the PostgreSQL user, you can log in to the database server using the psql command

**Installation completePostgreSQL 15 on AlmaLinux 8, wishing you every success!**

Through the guide above, you can now install PostgreSQL 15 on AlmaLinux 8, initialize a database cluster, create users, create databases, and configure remote connections.

For security reasons, do not expose port 5432 to the entire Internet or allow applications to use the administrative postgres account. Restrict IPs via firewall, use dedicated users, set strong passwords, update PostgreSQL regularly, and schedule periodic data backups.

If you need a Linux VPS to deploy PostgreSQL, websites, APIs, or enterprise software, you can check out the Cloud VPS services atVPTS. The VPS system utilizes SSD/NVMe drives, supports multiple configurations, and is suitable for deploying applications using PostgreSQL databases.

VPTS is a digital infrastructure solution provider in Vietnam, serving deployment, operation, and data storage needs for individuals, developers, and enterprises. The service ecosystem includesVietnam VPS, International VPS, VPS Anti DDoS, Hosting cPanel, dedicated server, Rack rental, Proxy IPv4/IPv6, S3 MinIOandCloud Storage.

Besides providing infrastructure resources, VPTS also focuses on assisting customers with deployment, configuration, and practical troubleshooting. Content on the VPTS Blog is drawn from common scenarios in operating VPS, servers, and online systems, helping readers understand root causes and apply clear solutions.

VPTS – Stable infrastructure, flexible solutions, and continuous partnership throughout operations.

Website: https://vpts.shop

Facebook: https://www.facebook.com/trang.vpsttt/

Zalo OA: https://zalo.me/vpstttgroup

Hotline: 0328 812 674