Thread: Ubuntu 14.04 (trusty) Postgres 13 deb package

On 6/24/21 2:33 PM, Bhavesh Mistry wrote:
> Hi All,
> 
> I was trying to install PSQL 13 on Ubuntu 14.04 (trusty)  but I could 
> not find the package.  It seems the path has been removed.  Can you 
> please tell me how to build deb package for trusty from psql source? I 
> tried psql 13 sources, I was able to build but I could not figure out 
> how to build deb package.  I would appreciate any pointers.

You won't find it per:

https://www.postgresql.org/download/linux/ubuntu/

  The PostgreSQL Apt Repository supports the current LTS versions of Ubuntu:

     20.04
     18.04
     16.04


There are the archive repos:

https://apt-archive.postgresql.org/pub/repos/apt/dists/index.html

Though for Trusty that only goes up to 11.

> 
> Also, the compile psql 13.3 , I could not figure out how to include 
> missing extensions sslinfo,uuid-ossp, and xml2 ?

If you mean to compile from source, you have to look in the contrib/ 
directory not src/

> 
> Here is apt repository error:
> W: Failed to fetch 
> http://apt.postgresql.org/pub/repos/apt/dists/trusty-pgdg/main/binary-amd64/Packages 
> <http://apt.postgresql.org/pub/repos/apt/dists/trusty-pgdg/main/binary-amd64/Packages> 
>   404  Not Found [IP: 147.75.85.69 80]
> 
> W: Failed to fetch 
> http://apt.postgresql.org/pub/repos/apt/dists/trusty-pgdg/main/binary-i386/Packages 
> <http://apt.postgresql.org/pub/repos/apt/dists/trusty-pgdg/main/binary-i386/Packages> 
>   404  Not Found [IP: 147.75.85.69 80]
> 
> 
> -- 
> Thanks,
> 
> Bhavesh
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 6/30/21 5:40 PM, Bhavesh Mistry wrote:
> Hi Joshua,
> 
> Thank you for your email.  I understand it is EOL, but I wanted to know 
> a way to build a deb package for myself.  I have succeeded 
> in building PSQL 13 on 14.04, but without some extensions so I am trying 
> it out.  Due to the legacy system, we had to use 14.04.

If you built the Postgres core you should be able to build the 
extensions. Note they are located in the contrib/ sub-directory, not the 
/src one. You may also have to install additional -dev libraries 
depending on the extension.

As to building deb package you might want to take a look at:

https://wiki.postgresql.org/wiki/Apt/RepoDocs

> 
> Thanks,
> 
> Bhavesh
> 
> On Mon, Jun 28, 2021 at 9:28 AM Joshua Drake <jd@commandprompt.com 
> <mailto:jd@commandprompt.com>> wrote:
> 
> 
>     On Sun, Jun 27, 2021 at 10:42 AM Bhavesh Mistry
>     <bhavesh.mistry13@gmail.com <mailto:bhavesh.mistry13@gmail.com>> wrote:
> 
>         Hi All,
> 
>         I was trying to install PSQL 13 on Ubuntu 14.04 (trusty)  but I
>         could not find the package.  It seems the path has been
>         removed.  Can you please tell me how to build deb package for
>         trusty from psql source? I tried psql 13 sources, I was able to
>         build but I could not figure out how to build deb package.  I
>         would appreciate any pointers.
> 
> 
>     Upgrade your Linux, 14.04 has been EOL for 2 years.
> 
>         -- 
>         Thanks,
> 
>         Bhavesh
> 
> 
> 
> -- 
> Thanks,
> 
> Bhavesh
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com