How to Install PostgreSQL 17 on Ubuntu 24.04 LTS Noble Numbat

570
Share:
how-to-install-postgresql-17-on-ubuntu-24-04-lts-noble-numbat

The installation process for PostgreSQL on Ubuntu is, like a lot of things in the Linux world, less than intuitive for new users. As much for my own benefit as anyone else's, now I am going to walk through the steps to getting PostgreSQL installed and configured on a Linux box.

Note: if you are an experienced Linux user, or a PostgreSQL DBA, this is not the post for you, even though your remarks and constructive criticism are very welcome – in case you see something either incorrect or missing, please do let me know inside the comments below.

So why PostgreSQL?

PostgreSQL is a amazing database platform. PostgreSQL is free, cross-platform, and gives an high-quality function set which, in my mind, exceeds the ones of its similar platform in the relational database area.

PostgreSQL offers all of the (mostly) standard-compliant SQL/relational database function you'll anticipate, plus a bunch of thrilling and innovative features. We’ll take a tour of PostgreSQL in every other posts, but first, let’s get the thing installed and running.

Installation steps for PostgreSQL 17 on Ubuntu 22.04 LTS Noble Numbat

By the time of this writing, the most up-to-date version of PostgreSQL is version 17, which was introduced at September 26, 2024. However, this latest version (17) is not available directly using the Advanced Packaging Tool (APT) or the Ubuntu Software Manager.

Fortunately, the PostgreSQL Global Development Group (PGDG) maintain an apt repository of PostgreSQL packages for Debian and Ubuntu-derived Linux distributions, located at http://apt.postgresql.org/pub/repos/apt/

Before we can install PostgreSQL, we have to add the package source for the distribution we are currently using. In case, I'm using Ubuntu 24.04 Noble Numbat. If your distribution is different than mine, adjust as necessary.

What's currently supported:

  • Debian bullseye (11), bookworm (12), trixie (testing/13) and sid (unstable)
  • Ubuntu focal (20.04), jammy (22.04), noble (24.04), oracular (24.10, amd64 only)
  • Architectures: amd64 (64-bit x86), arm64 (64-bit ARM), ppc64el (little-endian 64-bit POWER), s390x (IBM z-Series)
  • PostgreSQL 10, 11, 12, 13, 14, 15, 16, 17, 18 devel
  • Server extensions such as PostGIS, various PL languages, and datatypes
  • Applications like omnidb, pgbouncer, and pgpool-II

Add the PostgreSQL Package Source

We need to create a sources file reflecting the proper PostgreSQL source for our specific distribution. As noted above, in my case I'll need the source appropriate for the "Noble" release of Ubuntu. We can accomplish this by using Postgres's automated repository configuration script:

Install postgresql-common package

We need to download and install postgresql-common package with the following command:

$ sudo apt install -y postgresql-common

Install postgresql-common package

Run the PostgreSQL repository configuration script

After installing postgresql-common package, we run the automated repository configuration script:

$ sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

Add postgresql repository

Update, Upgrade, and Install PostgreSQL

Next step is updating system package source. Once this task is done, we proceed with upgrade packages to the latest versions.

$ sudo apt update
$ sudo apt upgrade

Please note that this can be a long process. Also, you may be prompted at several points to make some choices about configuration items. Specifically, you may informed that this that or the other configuration file has been changed, and asked if you want to keep your original version, or replace with the package maintainer’s version. Select "Y" to accept the package maintainer's version in these cases.

Finally, installing PostgreSQL 17:

$ sudo apt install postgresql
Postgresql Installation

Press "Y" and then "Enter". The system will then download all necessary files and continue with installation. By default, the PostgreSQL service is started automatically after the installation. It will also start automatically when the system boot.

Once the installation process finished, we can verify that we've installed PostgreSQL correctly. First we'll check if the service is running. Then we can check what version of PostgreSQL server is running.

$ sudo systemctl status postgresql
Check PostgreSQL service status

We can use the psql tool to connect with the PostgreSQL database server and printing its version:

$ psql --version

The output will be something like this:

psql (PostgreSQL) 17.0 (Ubuntu 17.0-1.pgdg24.04+1)

That’s it. You've successfully installed PostgreSQL to your system and you can start using it.

Configuring Postgres for Use

The postgres user

While PostgreSQL become installed, a system user account named postgres was also created with an identical user account in postgres. By default, the postgres user account isn't configured with a password, so it isn't viable to log into the server the use of the postgres user account without first creating a password for it. This postgres account has an all-access pass on your PostgreSQL database server, permission-wise. The postgres user account has similarities to the sa account in SQL server.

The postgres database

PostgreSQL is installed with a default database postgres. For the most part, we use the postgres database for administration functions, and create new databases on the PostgreSQL server to suit our needs.

The psql Command Line Utility

PostgreSQL consists of psql, a command line application for managing your databases and server. While a GUI-based software such as pgadmin4 is often  less complicated to use in the daily task, the command line utilty psql is always handy. psql gives total control of your postgres system from the terminal, together with the ability to execute SQL queries.

We will use psql to perform our preliminary configuration and to create an initial database super user.

Create super user account

In this step we will super-user account to deals with our database in the daily task.

To do this, we will get access to the postgres account through your machine root user. Then we'll use that postgres account to create a brand new super-user account for your PostgreSQL installation which can be regulated more efficiently. As an example we will use ethan as our new PostgreSQL super-user account.

$ sudo su -
[sudo] password for adjie:
root@cintra:~# su - postgres
postgres@cintra:~$ psql
psql (17.0 (Ubuntu 17.0-1.pgdg24.04+1))
Type "help" for help.

postgres=#
postgres=# CREATE USER ethan
postgres-# WITH SUPERUSER CREATEDB CREATEROLE
postgres-# PASSWORD 'pleasechangeme';

Notice in the above we can enter multiple lines of command in SQL shell. The SQL is not executed until semi-colon followed enter is found. Which means, the semi-colon will make the shell execute entered commands. Once it detects semi-colon, the command will be executed and it will respond with "CREATE ROLE" message and showing postgresql shell again.

CREATE ROLE
postgres=#
Create PostgreSQL admin user

Login using our newly created account

Let's verify that everything is working correctly. Try to log in with psql using our new super-user account and create a quick test database:

$ psql -h localhost -U ethan postgres
Password for user ethan:
psql (17.0 (Ubuntu 17.0-1.pgdg24.04+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off, ALPN: postgresql)
Type "help" for help.

postgres=#

Note in the above terminal session, we specified the postgres default database when we logged in, since there aren't yet any other databases to connect to.

Create test database

Next test is to create test database test_database using our new super-user account:

postgres=# CREATE DATABASE test_database WITH OWNER ethan;
CREATE DATABASE
postgres=# \connect test_database;
You are now connected to database "test_database" as user "ethan".
test_database=#

If everything works as shown, then congratulations. Now you have a working installation of PostgreSQL 17 on Ubuntu 24.04 Noble Numbat.

Final Words

I hope that you now know how to install PostgreSQL 17 on Ubuntu 24.04 Noble Numbat. If you run into any issues or have any feedback feel free to drop a comment below.

Reference

https://wiki.postgresql.org/wiki/Apt

Tags Linux
Share:

0 comment

Leave a reply

Your email address will not be published. Required fields are marked *