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 1siXMZ-005qmu-Aw for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:54:19 +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 1siXMW-008MBK-TD for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:54:17 +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 1siXMW-008M8j-FE for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:54:17 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1siXMP-001ZIr-7S for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:54:16 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-a7ab5fc975dso410902966b.1 for ; Mon, 26 Aug 2024 03:54:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724669648; x=1725274448; 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=BAGXbQS71UelrNAWKdtEcN+waq360c2z8Wbym1d0BiY=; b=Hy9SErt0cvBS83XSrUSPPYgE3IQogFkVsLl0YsuVAq6SwtccoM9MvCgFtNnqxCZ5eI E+RFIJ+hoSFy7/KYrgvcU39yuCy8r3JpliokIH5br/m2R9M5K0RQ4mfBGX1+63fu2gbs 7Y9SxP40mpKmQUaSKlJ7ozJjHKquJHB4gPbvpNtuKFlCbdQG8J1IgovUNSwSOK6Mv9m7 EcHESon/iFyKGO3Qw3CGyauoP6U5o6SmfrRf937DoFvsp1I2sN0R9WpPLPNAywZ90M8K tf9AxZ5Ac8fpV4CRBBFB2cw5p6ciji+vo+hzcI07nG0H4m+HSFp6TerG7Eln+VYYosLQ igQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724669648; x=1725274448; 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=BAGXbQS71UelrNAWKdtEcN+waq360c2z8Wbym1d0BiY=; b=uM+NDyK21zMi0DHNakb9AeTW3HgmU0cTrBjztxzZoYoalBrga/oCEKtHrb/T2msUAS wlCS7zPQPuRJGX7cXaN32ajRlEuypw9K5x1EbBIVbeM9WLid1Bx8UKrkXRAk8hJJmvQS EY9NiOT/GELrKh9ffd7OPvtzBdOwAwxX6z1PQBzTfj8lM5ey9eNkFuRyHyhGgignknju yx1SjXstpYOFlTNWlfYK9nQdrOHAhd9VGIlhSbmr3nyNLEP6cMyNUBlC5Z7TR2kBXrYx WUY7Bl8upI+4lLnxJHXv1Zy3pNyyrwhMjRnQ2Zq2sbkEEKh+mZczK3Tu52p0kx4iYE1p VhIA== X-Gm-Message-State: AOJu0YzlX8Za1+ShR+9YBkBGjiZdS05Xcv6tw0A14KlAGDjTKzHkZ8fX Xr435FicL6hom++zrwb+RKi/X4X62JWj9oJhgPPYivVp/oBU9iYTvpeyLHHbNzBeSzFc4gLZikE rAy8f50VyLUhLmyZ2kZFseNInQGw= X-Google-Smtp-Source: AGHT+IHqRqfIw4ZxT3gRmVRu1KkWeYvqi7n5PwQeBAlwC4nB7oXJ/WPoEmUm92v9ADDXWcdEqFeTTDuWtR/IwNPfJgk= X-Received: by 2002:a17:907:72d0:b0:a86:8196:e04d with SMTP id a640c23a62f3a-a86a530539dmr590802966b.39.1724669648246; Mon, 26 Aug 2024 03:54:08 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jyoti Saxena Date: Mon, 26 Aug 2024 16:23:56 +0530 Message-ID: Subject: Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy) To: Kashif Zeeshan Cc: postgre Content-Type: multipart/alternative; boundary="000000000000bd1f09062093f120" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bd1f09062093f120 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, Thank you for the suggestion to compile PostgreSQL from source. However, I am currently looking for a way to install PostgreSQL 17 through a package manager or a precompiled version that can be more seamlessly integrated and managed in my environment. Could you please confirm if PostgreSQL 17 is available through the PostgreSQL APT repository for Ubuntu 22.04, or if there will be a delay in its availability? Additionally, if you have any other recommendations for installing PostgreSQL 17 without compiling from source, such as through third-party repositories or Docker, I would appreciate your guidance. Also, could you please provide information on where I can find the binary installation packages for PostgreSQL 17 for Windows? This would be extremely helpful for setting up PostgreSQL on my Windows system. Thank you once again for your support. Best regards, Jyoti On Mon, Aug 26, 2024 at 4:02=E2=80=AFPM Kashif Zeeshan wrote: > 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 se= tup, >>> 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.0= 4+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 reposi= tory >>> 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 >> there. >> If you require PG17 beta for Testing purposes then you can install it >> from 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 >>>> 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 < >>>> jyotisaxena.mcm@gmail.com> 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= 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... DoneBuilding dependency tree... DoneReading = state information... DonePackage postgresql-17 is not available, but is ref= erred to by another 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: >>>>> >>>>> 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.= Could >>>>> you please advise on how to resolve this issue or if there's somethin= g I >>>>> might be missing? >>>>> >>>>> Thank you in advance for your help! >>>>> >>>>> Best regards, >>>>> >>>>> Jyoti >>>>> >>>> --000000000000bd1f09062093f120 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hello,

Thank you for the suggestion to compile Po= stgreSQL from source. However, I am currently looking for a way to install = PostgreSQL 17 through a package manager or a precompiled version that can b= e more seamlessly integrated and managed in my environment.

Could you= please confirm if PostgreSQL 17 is available through the PostgreSQL APT re= pository for Ubuntu 22.04, or if there will be a delay in its availability?= Additionally, if you have any other recommendations for installing Postgre= SQL 17 without compiling from source, such as through third-party repositor= ies or Docker, I would appreciate your guidance.

Also, could you plea= se provide information on where I can find the binary installation packages= for PostgreSQL 17 for Windows? This would be extremely helpful for setting= up PostgreSQL on my Windows system.

Thank you once again for your su= pport.

Best regards,=C2=A0

Jyoti


On Mon, Aug 26, 2024 at 4:0= 2=E2=80=AFPM Kashif Zeeshan <= kashi.zeeshan@gmail.com> wrote:
To compile PG from code follow the = below instructions.

Thanks
Kashi= f Zeeshan

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


On Mon, Aug 26, 2024 at 3:= 19=E2=80=AFPM Jyoti Saxena <jyotisaxena.mcm@gmail.com> 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 setup= , the system installed PostgreSQL 16.4 instead of the expected PostgreSQL 1= 7. The version installed is psql (PostgreSQL) 16.4 (Ubuntu 16.4-1.pgdg22.04= +1).

Here are the steps I followed:

  1. Installed curl an= d ca-certificates.
  2. Set up the repository key and configuration as i= nstructed.
  3. Ran apt-get update.
  4. Executed sudo apt -y install= postgresql.
The repository seems to have installed the latest ava= ilable version as PostgreSQL 16.4. Could you please advise if there is a di= fferent repository I should use for PostgreSQL 17, or if additional steps a= re needed to specifically target version 17?
So the last version available is PG16, which means PG17 is stil= l not there.
If you require PG17 beta for Testing purposes then y= ou can install it from code, which is available on following=C2=A0

Thank you for your assistance.

Best regards,=C2=A0
Jyoti

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

Make sure you have done the= following repo setup

sudo apt install curl ca-cer= tificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl= -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail h= ttps://www.postgresql.org/media/keys/ACCC4CF8.asc

# Create the r= epository configuration file:
sudo sh -c 'echo "deb [signed-by= =3D/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgr= esql.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 ins= tall the latest version of PG in this case PG17.
sudo apt -y inst= all postgresql

Regards
Kashif Zeesha= n

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 pack=
age lists... Done
Bu=
ilding dependency tree... Done
Re=
ading state information... Done
Pa=
ckage postgresql-17 is not available, but is referred to by another package=
.
Th=
is may mean that the package is missing, has been obsoleted, or is only ava=
ilable 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

--000000000000bd1f09062093f120--