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 PM Kashif Zeeshan <kashi.zees...@gmail.com> wrote: > > > On Mon, Aug 26, 2024 at 3:19 PM Jyoti Saxena <jyotisaxena....@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 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? >> > > 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 PM Kashif Zeeshan <kashi.zees...@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=/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....@gmail.com> >>> 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... DoneBuilding dependency tree... DoneReading state >>>> information... DonePackage 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 >>>> >>>
