PostgreSQL, an open-source relational database management system, is widely renowned for its robust features and extensibility. While many Linux distributions provide PostgreSQL through their package managers, installing it from the source allows for greater customization and control.
In this article, we will explain how to install PostgreSQL 16 using source code installation on Linux systems.
For those seeking an easier installation method from the distribution package manager, please follow the guides below:
Prerequisites
Before diving into the PostgreSQL installation process, ensure your system meets the following prerequisites:
- A Linux distribution (in this guide, we’ll use Debian for demonstration purposes).
- A Linux system with a non-root user with sudo privileges.
- Essential development tools such as GCC and Make are installed.
1. Install Prerequisites on Linux
First, install essential development tools such as GCC and Make using the distribution package manager as shown.
On RHEL-based distributions such as CentOS, Fedora, Rocky Linux and Alma Linux:
sudo yum groupinstall development-tools sudo yum install zlib-devel readline-devel libicu-devel
On Debian-based distributions such as Ubuntu and Linux Mint.
sudo apt install gcc build-essential zlib1g-dev libreadline6-dev libicu-dev pkg-config
2. Download the PostgreSQL Source Code
Once needed prerequisites are installed, download the source code tar file from the official postgres website using the following wget command directly on the system. As of writing, the latest version is PostgreSQL 16.1.
wget https://ftp.postgresql.org/pub/source/v16.1/postgresql-16.1.tar.bz2
Next, use the tar command to extract the downloaded tarball file. A new directory named postgresql-16.1 will be created.
tar -xvf postgresql-16.1.tar.bz2 cd postgresql-16.1/ ls -l
Sample Output:
-rw-r--r--. 1 tecmint tecmint 365 Nov 7 03:34 aclocal.m4 drwxr-xr-x. 2 tecmint tecmint 4096 Nov 7 03:47 config -rwxr-xr-x. 1 tecmint tecmint 584560 Nov 7 03:34 configure -rw-r--r--. 1 tecmint tecmint 87292 Nov 7 03:34 configure.ac drwxr-xr-x. 61 tecmint tecmint 4096 Nov 7 03:47 contrib -rw-r--r--. 1 tecmint tecmint 1192 Nov 7 03:34 COPYRIGHT drwxr-xr-x. 3 tecmint tecmint 4096 Nov 7 03:47 doc -rw-r--r--. 1 tecmint tecmint 4288 Nov 7 03:34 GNUmakefile.in -rw-r--r--. 1 tecmint tecmint 277 Nov 7 03:34 HISTORY -rw-r--r--. 1 tecmint tecmint 64601 Nov 7 03:48 INSTALL -rw-r--r--. 1 tecmint tecmint 1875 Nov 7 03:34 Makefile -rw-r--r--. 1 tecmint tecmint 102017 Nov 7 03:47 meson.build -rw-r--r--. 1 tecmint tecmint 6266 Nov 7 03:34 meson_options.txt -rw-r--r--. 1 tecmint tecmint 1213 Nov 7 03:34 README drwxr-xr-x. 16 tecmint tecmint 4096 Nov 7 03:48 src
3. Configure PostgreSQL from Source
As postgres is an open-source database, it can be built from source code according to one’s needs/requirements. we can customize the build and installation process by supplying one or more command line options for various additional features.
Use the following command for help with various options and configuration usage, as shown.
./configure --help
Now run the configure script, which will check your system for dependencies and configure the build accordingly.
./configure
4. Install PostgreSQL from Source
Once configured, use the following commands to build and install PostgreSQL from the source.
make sudo make install
5. Creating Postgres User
Now create a postgres user and directory to be used as a data directory for initializing the database cluster. The owner of this data directory should be a postgres user and permissions should be 700 also set a path for postgresql binaries for our ease.
sudo useradd postgres sudo passwd postgres sudo mkdir -p /pgdatabase/data sudo chown -R postgres: /pgdatabase/data sudo sh -c "echo 'export PATH=$PATH:/opt/PostgreSQL/bin' > /etc/profile.d/postgres.sh" source /etc/profile.d/postgres.sh
6. Initializing Postgres Database
Now initialize the database using the following command as a postgres user before using any postgres commands.
su postgres initdb -D /pgdatabase/data/ -U postgres -W
Where -D
is the location for this database cluster or we can say it is the data directory where we want to initialize the database cluster, -U
for database superuser name and -W
for password prompt for db superuser.
For more info and options we can refer to initdb --help
.
7. Start PostgreSQL Service
After initializing the database, start the database cluster, or if you need to change the port or listen to the address for the server, edit the /pgdatabase/data/postgresql.conf file in the data directory of the database server.
nano /pgdatabase/data/postgresql.conf
Now, start the PostgreSQL service.
pg_ctl -D /pgdatabase/data/ start
After starting the database, verify the status of the postgres server process by using the following ps and netstat commands.
ps -ef |grep -i postgres netstat -apn |grep -i 51751
We can see that the database cluster is running fine, and startup logs can be found at the location specified with -l
option while starting the database cluster.
pg_ctl -D /pgdatabase/data/ -l logfile start
8. Connect to PostgreSQL
Now connect to the database cluster and create a database by using the following commands.
psql -p 5432 postgres=# create database test; postgres=# l to list all databases in cluster postgres=# q to quit form postgres console
If you are looking for a graphical tool called pgAdmin to manage your PostgreSQL, then follow these guides to install pgAdmin on your Linux distribution.
Conclusion
You have successfully installed PostgreSQL from source on your Linux system. This process provides flexibility and control over your PostgreSQL installation, allowing you to tailor it to your specific requirements.
Discover more from Hosting Mate
Subscribe to get the latest posts sent to your email.