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 1siXaG-005v0s-7e for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 11:08:28 +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 1siXaD-008dVF-HQ for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 11:08:26 +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 1siXaD-008dV7-3r for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 11:08:25 +0000 Received: from mail-ua1-x92d.google.com ([2607:f8b0:4864:20::92d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1siXaA-001ZR5-FF for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 11:08:25 +0000 Received: by mail-ua1-x92d.google.com with SMTP id a1e0cc1a2514c-842f95b73daso1303960241.0 for ; Mon, 26 Aug 2024 04:08:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724670502; x=1725275302; 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=bPDMDX3kJsa5G2kV12/ny6vANxhAgnFAJ3BqkIKZ7rA=; b=cbB2rVObh9+7eRO7+qRFPYdkOKwxs1cddrTElWkNKZNm+9rTp6ThUBZf+8WuvWiuJV sRnBznd860yr0H0njdhC9qzCKp+RF1eeTKr7Z83kVws2e6Yn2HA4/jPOg3x6kfU/NpZV K5tBeoA3FId1VPvrRpTH74nJqW/hHK9fpkaz19VFbxFh10PEZhMRk7f9ROOsxUEXwzMm LqyIRs2gnEzSxxIDCAQkopXVqXC+eKifjbG59c9AFVOZ4krtMsh1GbilsbQWXIkc6qEr kuZUgK8/78oil82hW2/nfZ4p3U8oq5ZGTvhBjLsqyA4wmjYHGEaKAjz+3Q1nsN067Usd uJxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724670502; x=1725275302; 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=bPDMDX3kJsa5G2kV12/ny6vANxhAgnFAJ3BqkIKZ7rA=; b=u7R+j7lla8Br3bOYVRi7+1mdClgrD/AWVZfiTtNGBmR3JFFcoVNev0Qu3WG/xMzQbO LwTDH2ZmP36FbIDyxX/Ox+vAdOvZHqz7Nvowww0Po391/p8j68qP6jUH/G9DG1QoOz1V +jKrKHNtpyTKzLA4edEY6ZPOYsf/lpHk1wDUZbCCzcxwn4dpBozEt3ws5u5kKZIEQR8i fH5D2UhViKH8870iJfXUxs1S+tb5YJ1HFmhyouM821Tt6fNgXLlcSwSMWQEQ5kkf8Le8 nGJdi3VYIo6dMwc8QAQuqLqnBVBewAurGHohU7urXftHaek4TN6EoOr79EOcSV47l0h/ GcIA== X-Gm-Message-State: AOJu0YyoAFEFmF/boWEtUcPXbwcBwrg8UVVDmwqJ7eWWBbzgw+5+g0Ly Q4cUZWUWRhbE3lsSPUmMWGQH1KqO/rgHfvGUIFmmJOmXqR36xQSPKxObYDI9J+0o3yVuK/9F9AS MKfKRoR/hXMbyFx8LzFuuQlyDY7oQ1CWE X-Google-Smtp-Source: AGHT+IHbyqVXWZ0nYlNSCsELwUZtJyS+TB3bpQdDGLmMtj4AEctqvIrIfI5eXIhYGa6LgsVj0ZnwXe99nk1bUde1Gl0= X-Received: by 2002:a05:6122:218b:b0:4ef:27e0:3f8c with SMTP id 71dfb90a1353d-4fd1a3bf02amr12490122e0c.0.1724670502053; Mon, 26 Aug 2024 04:08:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Mon, 26 Aug 2024 16:08:10 +0500 Message-ID: Subject: Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy) To: Jyoti Saxena Cc: postgre Content-Type: multipart/alternative; boundary="000000000000a12f5706209424a4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a12f5706209424a4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Aug 26, 2024 at 3:54=E2=80=AFPM Jyoti Saxena wrote: > 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 a= nd > 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 i= n > 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. > Hi If the package is not available on repo then you cant install it using it. The other option is to compile using code. As far as PG17 is concerned then its Beta 3 is released, maybe someone else can guide on how to install it. Regards Kashif Zeeshan > 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. > For windows follow the link https://www.postgresql.org/download/windows/ > 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 u= p >>>> the repository and install PostgreSQL. However, after completing the s= etup, >>>> the system installed PostgreSQL 16.4 instead of the expected PostgreSQ= L 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 repos= itory >>>> 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 < >>>> kashi.zeeshan@gmail.com> 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 instruction= s 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 re= ferred 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 somethi= ng I >>>>>> might be missing? >>>>>> >>>>>> Thank you in advance for your help! >>>>>> >>>>>> Best regards, >>>>>> >>>>>> Jyoti >>>>>> >>>>> --000000000000a12f5706209424a4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, Aug 26, 2024 at 3:54=E2=80=AF= PM Jyoti Saxena <jyotisaxen= a.mcm@gmail.com> wrote:

Hello,

Thank you for the suggestio= n to compile PostgreSQL from source. However, I am currently looking for a = way to install PostgreSQL 17 through a package manager or a precompiled ver= sion that can be more seamlessly integrated and managed in my environment.<= /p>

Could you please confirm if PostgreSQL 17 is available through the Po= stgreSQL APT repository for Ubuntu 22.04, or if there will be a delay in it= s availability? Additionally, if you have any other recommendations for ins= talling PostgreSQL 17 without compiling from source, such as through third-= party repositories or Docker, I would appreciate your guidance.

Hi
If the package is not available on repo then y= ou cant=C2=A0install it using it.
The other option is to compile = using code.
As far as PG17 is concerned=C2=A0then its Beta 3 is r= eleased, maybe someone else can guide on how to install it.

<= /div>
Regards
Kashif Zeeshan=C2=A0

Also, could you please pro= vide information on where I can find the binary installation packages for P= ostgreSQL 17 for Windows? This would be extremely helpful for setting up Po= stgreSQL on my Windows system.

=C2=A0For windows= follow the link

<= p>Thank you once again for your support.

Best regards,=C2=A0

Jy= oti


On Mon, Aug 26, 2024 at 4:02=E2=80=AFPM Kashif Zeeshan <kashi.zeeshan@gmail.c= om> wrote:
To compile PG from code follow the below instructions.https://www.postgresql.org/docs/current/install-make.html

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


On Mon, Aug 26, 2024 at 3:19=E2=80=AFPM Jyoti Saxe= na <jyoti= saxena.mcm@gmail.com> wrote:
Hi Kashif,

Thank you for the in= structions. I followed the steps provided to set up the repository and inst= all PostgreSQL. However, after completing the setup, the system installed P= ostgreSQL 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. <= li>Set up the repository key and configuration as instructed.
  2. Ran a= pt-get update.
  3. Executed sudo apt -y install postgresql.
Th= e repository seems to have installed the latest available version as Postgr= eSQL 16.4. Could you please advise if there is a different repository I sho= uld use for PostgreSQL 17, or if additional steps are needed to specificall= y target version 17?

So the last = version available is PG16, which means PG17 is still not there.
I= f you require PG17 beta for Testing purposes then you can install it from c= ode, which is available on following=C2=A0


Thank you for your as= sistance.

Best regards,=C2=A0
Jyoti

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

Make sure you have done the following repo setup

sudo apt install curl ca-certificates
sudo insta= ll -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgres= ql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.o= rg/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.lis= t'



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

Regards
Kashif Zeeshan

On Mon, Aug 26, 2= 024 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 another package.
This may mean that the package is missing, has been obs=
oleted, 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

--000000000000a12f5706209424a4--