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 1siX1B-005mIE-7j for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:32:13 +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 1siX19-0081cO-Dg for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:32:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1siX19-0081cE-1D for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:32:11 +0000 Received: from mail-ua1-x92f.google.com ([2607:f8b0:4864:20::92f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1siX15-001Z7e-NM for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:32:10 +0000 Received: by mail-ua1-x92f.google.com with SMTP id a1e0cc1a2514c-844f07f6205so456539241.0 for ; Mon, 26 Aug 2024 03:32:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724668327; x=1725273127; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=NO5O94M4vUMb/Ho9hkJViI+3jCpBXvyk47LfbbpZVfs=; b=Y0ouu0LA2QLLQyStOAQJqTUBtt5i6KTRM/Z7wakJH+wi5Y7Slk+zOxf8MWJc05mS4I b7JW0nuIUyAaYFBJrmkfViQmpMNRe8b9nHegy5pRtXSPN+s2uOqPtEwr0h/rOWshFrpP ja5RijmFCgsXClNqmL+/rjlHiUypwh5hAsQCdeA3GKa0/JFcyyV20AnkZk9YK9b+Re1n oMibpAbxdde3211tj99FRB/ASU3SvfpokmVoylMGJHF4caiZfQ2gUgkMqG8Rnq7hjS8V OL1CtIeIA8eKX0GV6jFAHcjZ6BeKRHQR9Yo7bzLV57R66eFJiWPLx9jWQ1kHSg9wSFTL Czkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724668327; x=1725273127; h=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=NO5O94M4vUMb/Ho9hkJViI+3jCpBXvyk47LfbbpZVfs=; b=ox0GGJ30YAHOLFRlK6odqlI7eXaDVpJwCsRqZJGsnx5RFjl7B5oqgELl1mKT7VDCXQ 9SwVboUdyeYKGMdN3zNQ5fZPKDL4GdRzQRJQpox9b4W8Br8+5oX9QHRAlJtG+YIoJOgi Xq0thQHQIt7xPJjty47BInS4ermQiVZ4ygfpCP6zX11ojNYw46ECLZVHwjvnvM5uy7qN FtQ+DaNoPltNbACVuumyxoO5mAIb/h62CGw7cfhCbtjq+t/gHGFc+HU4eOj6zNI+bxoX k/WIspq98z3dSeG2c+SAjs8DFCC6kzONmA+cezEjA+WGYUpfk2zPgDsOzNZ3B+hQ8d0f yFSg== X-Forwarded-Encrypted: i=1; AJvYcCXJ4Ri6Hw2CgMUJuwmvYIg+p/edOd/A2chKPIIXIR+RcdYWv2VwE9+dUraq7XfHIQZD+TAFOAYAvogw/xw4@lists.postgresql.org X-Gm-Message-State: AOJu0YyAl5PcfBtf1s4VTbtQY4GOztdfYUAS9vj5geOayA0d9Frx852g 4fnLkfkM8Azzr1JUG0Xm17xl2lvihx3TC5klWdW5HoZYoeAqACoN4lfnz0lCoJ6KzcX5CgZQq8o bIJBDpCI4XROCIdAR5i5PRhrHHI6iyZnM X-Google-Smtp-Source: AGHT+IGzkRq4Mkj2MlhLlYkB8sW1LVRLQY8UHcgTswmEDduSNeBDHCTfx3O5xDB3tzucfphqriORsGDmvNqtBLXdMQ0= X-Received: by 2002:a05:6102:e09:b0:498:d013:4cd1 with SMTP id ada2fe7eead31-498f471a1f8mr11416919137.26.1724668327240; Mon, 26 Aug 2024 03:32:07 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Mon, 26 Aug 2024 15:31:55 +0500 Message-ID: Subject: Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy) To: Jyoti Saxena , postgre Content-Type: multipart/alternative; boundary="000000000000002e68062093a374" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000002e68062093a374 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable To compile PG from code follow the below instructions. https://www.postgresql.org/docs/current/install-make.html Thanks Kashif Zeeshan On Mon, Aug 26, 2024 at 3:30=E2=80=AFPM Kashif Zeeshan wrote: > > > On Mon, Aug 26, 2024 at 3:19=E2=80=AFPM Jyoti Saxena > wrote: > >> Hi Kashif, >> >> Thank you for the instructions. I followed the steps provided to set up >> the repository and install PostgreSQL. However, after completing the set= up, >> 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 reposit= ory >> I should use for PostgreSQL 17, or if additional steps are needed to >> specifically target version 17? >> > > So the last version available is PG16, which means PG17 is still not ther= e. > If you require PG17 beta for Testing purposes then you can install it fro= m > code, which is available on following > > https://www.postgresql.org/ftp/source/v17beta3/ > >> >> 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 versio= n >>> 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 1= 7 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 th= e >>>> following message: >>>> >>>> Reading package lists... DoneBuilding dependency tree... DoneReading s= tate information... DonePackage postgresql-17 is not available, but is refe= rred to by another package.This may mean that the package is missing, has b= een 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 wit= h >>>> >>>> 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. = Could you >>>> please advise on how to resolve this issue or if there's something I m= ight >>>> be missing? >>>> >>>> Thank you in advance for your help! >>>> >>>> Best regards, >>>> >>>> Jyoti >>>> >>> --000000000000002e68062093a374 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
To compile PG from code follow the below instructions.http= s://www.postgresql.org/docs/current/install-make.html
Thanks
Kashif Zeeshan

On Mon, Aug 26, 2024 at 3:= 30=E2=80=AFPM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:


On Mon, Aug 2= 6, 2024 at 3:19=E2=80=AFPM Jyoti Saxena <jyotisaxena.mcm@gmail.com> wrote:
H= i Kashif,

Thank you for the instructions. I followed the steps provi= ded to set up the repository and install PostgreSQL. However, after complet= ing 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. Inst= alled curl and ca-certificates.
  2. Set up the repository key and confi= guration as instructed.
  3. Ran apt-get update.
  4. Executed sudo a= pt -y install postgresql.
The repository seems to have installed t= he 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 addit= ional steps are needed to specifically target version 17?

So the last version available is PG16, which means= PG17 is still not there.
If you require PG17 beta for Testing pu= rposes then you can install it from code, which is available on following= =C2=A0


Thank you for your assistance.

Best regards,=C2=A0<= div>Jyoti

On Mon, Aug 26, 2024 at 12:35=E2=80=AFPM Kashif Zeeshan = <kashi.zees= han@gmail.com> wrote:
Hi=C2=A0Jyoti

Make sure yo= u have done the following repo setup

sudo apt inst= all curl ca-certificates
sudo install -d /usr/share/postgresql-common/pg= dg
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] = http= s://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main"= > /etc/apt/sources.list.d/pgdg.list'

<= br>
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.
su= do apt -y install postgresql

Regards
Kashif Zeeshan

On Mon, Aug 26, 2024 at 11:52=E2=80=AFAM Jyoti Saxena = <jyotisax= ena.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 tre=
e... Done
Reading state informati=
on... Done
Package postgresql-17 i=
s 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 s=
ource.

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

--000000000000002e68062093a374--