PostgreSQL

Step-by-Step Guide to Installing and Configuring PostgreSQL 16 from Source on Ubuntu 24.04 VPS

Philip Jensen

— 2 min read

Introduction

At ByteHosting, we understand that for many developers and system administrators, having maximum control over your database server is essential. Installing PostgreSQL 16 from source on Ubuntu 24.04 VPS allows you to fine-tune your setup for optimal performance and customization. In this step-by-step guide, we’ll walk you through the entire process, from prerequisites to verifying your installation, ensuring you can confidently deploy PostgreSQL 16 on your fresh VPS.

Prerequisites: Setting up Your Ubuntu 24.04 VPS

Before diving into the installation, ensure your VPS is running Ubuntu 24.04 and that you have root or sudo privileges. We recommend starting with a clean VPS to avoid conflicts. For this guide, we assume you’re using one of our reliable KVM-based VPS plans, which provide the performance and stability needed for database hosting.

Update your system packages to ensure you have the latest security patches and dependencies:

sudo apt update && sudo apt upgrade -y

Downloading PostgreSQL 16 Source Code

Next, download the latest PostgreSQL 16 source code from the official PostgreSQL repository. It’s best to use the official source to ensure stability and security.

Navigate to a directory where you want to download the source, then run:

wget https://ftp.postgresql.org/pub/source/v16.0/postgresql-16.0.tar.gz

Once downloaded, extract the archive:

tar -xzf postgresql-16.0.tar.gz

Change into the source directory:

cd postgresql-16.0

Compiling and Installing PostgreSQL 16 from Source

Before compiling, install the necessary dependencies:

sudo apt install build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt1-dev libssl-dev -y

Configure the build with desired options. For a standard installation, run:

./configure --prefix=/usr/local/pgsql

Compile the source code. This process may take several minutes depending on your VPS hardware:

make -j$(nproc)

And then install:

sudo make install

After installation, create a dedicated PostgreSQL user and data directory:

sudo adduser --disabled-password --gecos "" postgres
sudo mkdir /usr/local/pgsql/data
sudo chown postgres:postgres /usr/local/pgsql/data

Initialize the database cluster:

sudo -u postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

Finally, set up systemd service or start PostgreSQL manually for initial testing.

Configuring PostgreSQL for Optimal Performance

Configuration tuning is crucial for maximizing your PostgreSQL server’s performance. Edit the main configuration file:

sudo nano /usr/local/pgsql/data/postgresql.conf

Some key parameters to consider:

  • shared_buffers: Allocate 25-40% of your total RAM.
  • effective_cache_size: Set to about 50-75% of total RAM.
  • work_mem: Adjust based on workload, e.g., 4MB to 64MB.
  • maintenance_work_mem: Increase for faster vacuuming, e.g., 64MB.

For example:

shared_buffers = 1GB
effective_cache_size = 3GB
work_mem = 16MB
maintenance_work_mem = 128MB

Ensure to restart PostgreSQL after making changes:

sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data restart

Verifying the Installation and Initial Setup

Check that PostgreSQL 16 is running correctly:

sudo -u postgres /usr/local/pgsql/bin/pg_isready

Connect to the database:

sudo -u postgres /usr/local/pgsql/bin/psql

If you see the PostgreSQL prompt, your installation is successful. You can now create databases, users, and start using PostgreSQL 16 on your Ubuntu 24.04 VPS.

Troubleshooting Common Installation Issues

  • Missing dependencies: Ensure all required libraries are installed as per the build dependencies.
  • Permission errors: Verify ownership of data directories and correct user permissions.
  • Compilation failures: Check for compiler errors and ensure your system packages are up to date.

At ByteHosting, we’re committed to providing reliable infrastructure for your projects. If you encounter persistent issues, our support team is ready to assist you with your server setup and optimization.

Conclusion

Installing PostgreSQL 16 from source on Ubuntu 24.04 VPS gives you maximum control over your database environment. By following this guide, you can compile, install, and configure PostgreSQL tailored to your needs, ensuring high performance and stability. Whether you’re hosting a small project or a large-scale application, our VPS solutions in Frankfurt provide the perfect foundation for your database server. Trust ByteHosting for dependable, affordable hosting that empowers your development efforts.

Read more