Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1siWz9-005lfp-SP for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:30:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1siWz7-007nEH-HW for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:30:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1siWz6-007nE5-Uq for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:30:05 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1siWz3-001VEv-8e for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:30:03 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-a80eab3945eso401244566b.1 for ; Mon, 26 Aug 2024 03:30:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724668199; x=1725272999; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=XdyiPI5w1WmqNASFmffUt8Ots342hPnz640MBB660dM=; b=AjmFUMfcwdHrK2VUo7YogrYzB8eiU2syZw3EZkYvhhg9t8RKFETLmlCaNkKt+f4J4v 1O9QCiKIf60d/2CHM4RvzR8G2+tzD/zjWs00rK83Wn9rm6ntDKFFI7s7fIO+y+6UODzH k2zvIVuD2YlLlD55OzSpzULPkbbUfZ4PHhEOOT5lXm9aEkgdWDS6hAmrSTZOwH5SAPYI oMvVeQEm6pkgHESRJKPHYgw3OFEgeKOnxnbVhm2tX2wNqh+Khk/6phiJwOvyccxd5Pw+ 9CimKK0A2amFL5giIeD0Tvb0OUg2ov62EB020liESZPUkhkI03oTMaeDJtjC2QYcU91E Cwyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724668199; x=1725272999; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=XdyiPI5w1WmqNASFmffUt8Ots342hPnz640MBB660dM=; b=cTGPyC4Uxlmpl8FjcQsAyqz3/mNtHofP+JjoY8UKpowp0ujcSRG1VZTzqQ49HmU8og yawNX5pWEto/goxdX9v1IxZFuoBbYE8/qgeEbLMOGjxMaQs4Mwt/DcAtp2IqBCZMETr0 VmOu6QzZPwGywqaY6v0NSKka4b8Z5u0ux9ZP7egYhC0yIME5RNIZPny24fMnglleHhqQ 3XXBZNYEiXEeaim2Isl9Fqfs6bNlMTxdCQRZQ5gQZMLalEuBopuKcGR3QAxanupxbk4V Rsb9nnw+zhTXBCURdCLBmbTbR/0cPy0PXrivdbWT8P9+D4kpbMeh5s3XYiN/hG3rlbDh 7jGg== X-Gm-Message-State: AOJu0Yyq85Fl5ZJeJUoPh3PdQYhhm1/rKnKzr9oB2z6NhJMVWf6Xi8Ss SXAJrfkWuJz43aWC9SN1Ka3KYmXu4XM/trvlU26Vx0EwM+/CL2ElA/FVOnbMDKyi+ZjeYxPQCil BCo9vbKt7kpxM2bGJ46kTFz6DJKBDuIRJzQM= X-Google-Smtp-Source: AGHT+IErBtAh5MU9g5MylH6xDvyxSsAf7GUF4aCksZNGfOzCp/jwGe2Pm6BSC2/76Hm4OCyW7o2dPbj/iMmqZ4PTZDE= X-Received: by 2002:a17:906:f59c:b0:a86:9ba1:63ac with SMTP id a640c23a62f3a-a86a5168f27mr615943866b.14.1724668198211; Mon, 26 Aug 2024 03:29:58 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jyoti Saxena Date: Mon, 26 Aug 2024 15:59:45 +0530 Message-ID: Subject: Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy) To: Kashif Zeeshan Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004f5a9a0620939b4e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004f5a9a0620939b4e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Kashif, Thank you for the instructions. I followed the steps provided to set up the repository and install PostgreSQL. However, after completing the setup, the system installed PostgreSQL 16.4 instead of the expected PostgreSQL 17. The version installed is psql (PostgreSQL) 16.4 (Ubuntu 16.4-1.pgdg22.04+1). Here are the steps I followed: 1. Installed curl and ca-certificates. 2. Set up the repository key and configuration as instructed. 3. Ran apt-get update. 4. Executed sudo apt -y install postgresql. The repository seems to have installed the latest available version as PostgreSQL 16.4. Could you please advise if there is a different repository I should use for PostgreSQL 17, or if additional steps are needed to specifically target version 17? Thank you for your assistance. Best regards, Jyoti On Mon, Aug 26, 2024 at 12:35=E2=80=AFPM Kashif Zeeshan wrote: > 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=3D/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=E2=80=AFAM Jyoti Saxena > wrote: > >> Hi, >> >> I=E2=80=99m encountering an issue while trying to install PostgreSQL 17 = on my >> Ubuntu 22.04 (Jammy) system. I followed the installation instructions fr= om >> 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... DoneBuilding dependency tree... DoneReading sta= te information... DonePackage postgresql-17 is not available, but is referr= ed to by another package.This may mean that the package is missing, has bee= n obsoleted, or is only available from another source. >> >> Here=E2=80=99s what I=E2=80=99ve 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=E2=80=99m unable to install PostgreSQL 17. Co= uld you >> please advise on how to resolve this issue or if there's something I mig= ht >> be missing? >> >> Thank you in advance for your help! >> >> Best regards, >> >> Jyoti >> > --0000000000004f5a9a0620939b4e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Kashif,

Thank you for the instructions. I follow= ed the steps provided to set up the repository and install PostgreSQL. Howe= ver, after completing the setup, the system installed PostgreSQL 16.4 inste= ad of the expected PostgreSQL 17. The version installed is psql (PostgreSQL= ) 16.4 (Ubuntu 16.4-1.pgdg22.04+1).

Here are the steps I followed:
  1. Installed curl and ca-certificates= .
  2. Set up the repository key and configur= ation as instructed.
  3. Ran apt-get update.=
  4. Executed sudo apt -y install postgresql= .
The repository seems to have installed the latest available vers= ion as PostgreSQL 16.4. Could you please advise if there is a different rep= ository I should use for PostgreSQL 17, or if additional steps are needed t= o specifically target version 17?

Thank you for your assistance.
=
Best regards,=C2=A0
Jyoti

On Mo= n, Aug 26, 2024 at 12:35=E2=80=AFPM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Hi=C2=A0Jyot= i

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-c= ommon/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/m= edia/keys/ACCC4CF8.asc

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


Also once the above is done = then execute following
apt-get update

th= en execute the following command and it shd install the latest version of P= G in this case PG17.
sudo apt -y install postgresql

Regards
Kashif Zeeshan

On Mon, Aug 26, 2024= at 11:52=E2=80=AFAM Jyoti Saxena <jyotisaxena.mcm@gmail.com> wrote:

Hi,

I=E2=80=99m encountering an issue while trying to install P= ostgreSQL 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 ano=
ther package.
This may mean that the package is missing, has been obsoleted, or=
 is only available from another source.

Here=E2=80=99s what I=E2=80=99ve already tried:

=C2=A01. Updated the package list with sudo apt update.

=

=C2=A02. Verified that the PostgreSQL Apt Repository is add= ed correctly with=C2=A0

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

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

=C2=A04. Despite t= hese steps, I=E2=80=99m unable to install PostgreSQL 17. Could you please a= dvise on how to resolve this issue or if there's something I might be m= issing?

Thank you in advance for your help!

Best regards,

Jyoti

--0000000000004f5a9a0620939b4e--