Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy)

[Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>]

Hi Jyoti

Make sure you have done the following repo setup

sudo apt install curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc

# Create the repository configuration file:
sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Also once the above is done then execute following

apt-get update

then execute the following command and it shd install the latest version of PG in this case PG17.

sudo apt -y install postgresql

Regards

Kashif Zeeshan

On Mon, Aug 26, 2024 at 11:52 AM Jyoti Saxena <jyotisaxena.mcm@xxxxxxxxx> wrote:

Hi,

I’m encountering an issue while trying to install PostgreSQL 17 on my Ubuntu 22.04 (Jammy) system. I followed the installation instructions from the official PostgreSQL website https://www.postgresql.org/download/linux/ubuntu/.

When I run the command sudo apt -y install postgresql-17, I receive the following message:

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package postgresql-17 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available from another source.

Here’s what I’ve already tried:

 1. Updated the package list with sudo apt update.

 2. Verified that the PostgreSQL Apt Repository is added correctly with 

deb http://apt.postgresql.org/pub/repos/apt/ jammy-pgdg main. 

3. Checked available packages using apt-cache search postgresql-17.

 4. Despite these steps, I’m unable to install PostgreSQL 17. Could you please advise on how to resolve this issue or if there's something I might be missing?

Thank you in advance for your help!

Best regards,

Jyoti