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 1uRZsP-00DdBG-He for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 17 Jun 2025 17:13:37 +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 1uRZsN-00BaAP-AR for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 17 Jun 2025 17:13:35 +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 1uRZsN-00BaAH-13 for pgsql-pkg-debian@lists.postgresql.org; Tue, 17 Jun 2025 17:13:35 +0000 Received: from mail.rcmp-grc.gc.ca ([199.212.150.8]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uRZsK-002a8P-09 for pgsql-pkg-debian@postgresql.org; Tue, 17 Jun 2025 17:13:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=rcmp-grc.gc.ca; s=mail; t=1750180412; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=Awip2D921OZt1Zfm3vNORh3HXWS1tkCaEFUpGYmUJ3Y=; b=EJLIrN8zG+yFA+zzGXDFussPm8zxvbDE6zV3JscpXjWtlpqK6nJ+osDc RCCOG3INQeI85fB/PkIDzoKJgdLHpDh3CoEVoTzfNbcdy1nmE/swf/ujA bx0pVPQh5341HU3I4YgyfBeO0TWTkwx3hn9ceTVBOeFzuUB4ISOzfjPcb 4=; X-CSE-ConnectionGUID: gzGdADvQS6mv/Gps2/QOSA== X-CSE-MsgGUID: ow0P4NC8Tluw6ik9n+dQag== X-ExtLoop1: 1 X-IronPort-AV: E=Sophos;i="6.16,243,1744084800"; d="scan'208";a="19752738" listener: outgoing Received: from adr-s4553.dmz.rcmp-grc.gc.ca ([172.16.22.23]) by ACPIC-S1928-E1.dmz.rcmp-grc.gc.ca with ESMTP; 17 Jun 2025 13:13:29 -0400 Received: from ACPIC-S4181.natl.rcmp-grc.gc.ca (10.4.16.236) by ADR-S4553.dmz.rcmp-grc.gc.ca (172.16.22.23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.39; Tue, 17 Jun 2025 13:13:29 -0400 Received: from ACPIC-S4177.natl.rcmp-grc.gc.ca (10.4.16.232) by ACPIC-S4181.natl.rcmp-grc.gc.ca (10.4.16.236) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.39; Tue, 17 Jun 2025 13:13:28 -0400 Received: from ACPIC-S4177.natl.rcmp-grc.gc.ca ([fe80::304a:2308:ab24:1a59]) by ACPIC-S4177.natl.rcmp-grc.gc.ca ([fe80::304a:2308:ab24:1a59%3]) with mapi id 15.01.2507.039; Tue, 17 Jun 2025 13:13:28 -0400 From: "Hicks, David (RCMP/GRC)" To: Christoph Berg CC: "pgsql-pkg-debian@postgresql.org" Subject: RE: Jammy-pgdg repository Thread-Topic: Jammy-pgdg repository Thread-Index: Adve81zzZlu2AmJwSa2xRjU51oRYmwANTxEAACB254A= Date: Tue, 17 Jun 2025 17:13:27 +0000 Message-ID: <0ba6c40b700d4f32ba4a3d8d8358beff@rcmp-grc.gc.ca> References: <6b344ee18d874d95b6083cfecea9ac4c@rcmp-grc.gc.ca> In-Reply-To: Accept-Language: en-CA, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.188.10.222] Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk So I have the Key in: wicap@CR-DTAK-HQ:~$ ls /usr/share/postgresql-common/pgdg/apt.postgresql.or= g.asc /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc The contents of my pgdg.list is: wicap@CR-DTAK-HQ:~$ tail /etc/apt/sources.list.d/pgdg.list=20 deb [trusted=3Dyes signed-by=3D/usr/share/postgresql-common/pgdg/apt.postgr= esql.org.asc] https://apt.postgresql.org/pub/repos/apt jammy-pgdg main When I run apt-get update I get: wicap@CR-DTAK-HQ:~$ sudo apt-get update Hit:1 https://mirror.it.ubc.ca/ubuntu jammy InRelease Hit:2 https://mirror.it.ubc.ca/ubuntu jammy-updates InRelease Hit:3 https://mirror.it.ubc.ca/ubuntu jammy-backports InRelease = =20 Hit:4 https://mirror.it.ubc.ca/ubuntu jammy-security InRelease = =20 Ign:5 https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease = =20 Ign:5 https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease Ign:5 https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease Err:5 https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease Could not wait for server fd - select (11: Resource temporarily unavailab= le) [IP: 151.101.195.52 443] Reading package lists... Done =20 W: Failed to fetch https://apt.postgresql.org/pub/repos/apt/dists/jammy-pgd= g/InRelease Could not wait for server fd - select (11: Resource temporaril= y unavailable) [IP: 151.101.195.52 443] W: Some index files failed to download. They have been ignored, or old ones= used instead. And the result of the apt-cache search postgresql- is: wicap@CR-DTAK-HQ:~$ sudo apt-cache search postgresql- postgresql-14 - The World's Most Advanced Open Source Relational Database postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-14 - front-end programs for PostgreSQL 14 postgresql-client-common - manager for multiple PostgreSQL client versions postgresql-common - PostgreSQL database-cluster manager postgresql-contrib - additional facilities for PostgreSQL (supported versio= n) postgresql-doc - documentation for the PostgreSQL database management syste= m postgresql-doc-14 - documentation for the PostgreSQL database management sy= stem postgresql-plperl-14 - PL/Perl procedural language for PostgreSQL 14 postgresql-plpython3-14 - PL/Python 3 procedural language for PostgreSQL 14 postgresql-pltcl-14 - PL/Tcl procedural language for PostgreSQL 14 cl-sql-postgresql-socket - CLSQL database backend, PostgreSQL via sockets gnustep-dl2-postgresql-adaptor - gnustep-dl2 adaptor to connect to PostgreS= QL homer-api-postgresql - HOMER Capture Node REST API kexi-postgresql-driver - PostgreSQL support for kexi libghc-hdbc-dev - Haskell Database Connectivity, GHC package libghc-hdbc-postgresql-dev - PostgreSQL HDBC (Haskell Database Connectivity= ) Driver for GHC libghc-hdbc-postgresql-doc - PostgreSQL HDBC (Haskell Database Connectivity= ) documentation libghc-hdbc-postgresql-prof - PostgreSQL HDBC Driver for GHC; profiling lib= raries libghc-persistent-postgresql-dev - backend for the persistent library using= PostgreSQL libghc-persistent-postgresql-doc - backend for the persistent library using= PostgreSQL; documentation libghc-persistent-postgresql-prof - backend for the persistent library usin= g PostgreSQL; profiling libraries libghc-postgresql-libpq-dev - low-level binding to libpq libghc-postgresql-libpq-doc - low-level binding to libpq; documentation libghc-postgresql-libpq-prof - low-level binding to libpq; profiling librar= ies libghc-postgresql-simple-dev - mid-level PostgreSQL client library libghc-postgresql-simple-doc - mid-level PostgreSQL client library; documen= tation libghc-postgresql-simple-prof - mid-level PostgreSQL client library; profil= ing libraries libghc-text-postgresql-dev - Parser and Printer of PostgreSQL extended type= s libghc-text-postgresql-doc - Parser and Printer of PostgreSQL extended type= s; documentation libghc-text-postgresql-prof - Parser and Printer of PostgreSQL extended typ= es; profiling libraries libpostgresql-gst - PostgreSQL bindings for GNU Smalltalk libpostgresql-jdbc-java - Java database (JDBC) driver for PostgreSQL libpostgresql-jdbc-java-doc - Java database (JDBC) driver for PostgreSQL (d= ocumentation) libpostgresql-ocaml - OCaml bindings to PostgreSQL's libpq (runtime) libpostgresql-ocaml-dev - OCaml bindings to PostgreSQL's libpq libtap-parser-sourcehandler-pgtap-perl - Unit testing tools for pgTAP libtest-postgresql-perl - sets up and destroys temporary PostgreSQL instanc= es for testing lighttpd-mod-vhostdb-pgsql - PostgreSQL-based virtual host configuration mo= dule for lighttpd lua-dbi-postgresql-dev - DBI library for the Lua language, PostgreSQL devel= opment files pgagent - job scheduling engine for PostgreSQL postgresql-14-asn1oid - ASN.1 OID data type for PostgreSQL postgresql-14-auto-failover - Postgres high availability support postgresql-14-bgw-replstatus - report whether PostgreSQL node is master or = standby postgresql-14-cron - Run periodic jobs in PostgreSQL postgresql-14-debversion - Debian version number type for PostgreSQL postgresql-14-decoderbufs - logical decoder output plugin to deliver data a= s Protocol Buffers postgresql-14-dirtyread - Read dead but unvacuumed tuples from a PostgreSQL= relation postgresql-14-extra-window-functions - Extra Window Functions for PostgreSQ= L postgresql-14-first-last-agg - PostgreSQL extension providing first and las= t aggregate functions postgresql-14-hll - HyperLogLog extension for PostgreSQL postgresql-14-hypopg - PostgreSQL extension adding support for hypothetical= indexes. postgresql-14-icu-ext - PostgreSQL extension exposing functionality from th= e ICU library postgresql-14-ip4r - IPv4 and IPv6 types for PostgreSQL 14 postgresql-14-jsquery - PostgreSQL JSON query language with GIN indexing su= pport postgresql-14-mimeo - specialized, per-table replication between PostgreSQL= instances postgresql-14-mysql-fdw - Postgres 14 Foreign Data Wrapper for MySQL postgresql-14-numeral - numeral datatypes for PostgreSQL postgresql-14-ogr-fdw - PostgreSQL foreign data wrapper for OGR postgresql-14-omnidb - PostgreSQL PL/pgSQL debugger extension for OmniDB postgresql-14-orafce - Oracle support functions for PostgreSQL 14 postgresql-14-partman - PostgreSQL Partition Manager postgresql-14-periods - PERIODs and SYSTEM VERSIONING for PostgreSQL postgresql-14-pg-catcheck - Postgres system catalog checker postgresql-14-pg-checksums - Activate/deactivate/verify PostgreSQL data che= cksums postgresql-14-pg-fact-loader - Build fact tables asynchronously with Postgr= es postgresql-14-pg-qualstats - PostgreSQL extension to gather statistics abou= t predicates. postgresql-14-pg-stat-kcache - PostgreSQL extension to gather per-query ker= nel statistics. postgresql-14-pg-track-settings - PostgreSQL extension tracking of configur= ation settings postgresql-14-pg-wait-sampling - Extension providing statistics about Postg= reSQL wait events postgresql-14-pgaudit - PostgreSQL Audit Extension postgresql-14-pgauditlogtofile - PostgreSQL pgAudit Add-On to redirect audi= t logs postgresql-14-pgextwlist - PostgreSQL Extension Whitelisting postgresql-14-pgfincore - set of PostgreSQL functions to manage blocks in m= emory postgresql-14-pgl-ddl-deploy - Transparent DDL replication for PostgreSQL postgresql-14-pglogical - Logical Replication Extension for PostgreSQL postgresql-14-pglogical-ticker - Have time-based replication delay for pglo= gical postgresql-14-pgmemcache - PostgreSQL interface to memcached postgresql-14-pgmp - arbitrary precision integers and rationals for Postgre= SQL 14 postgresql-14-pgpcre - Perl Compatible Regular Expressions (PCRE) extension= for PostgreSQL postgresql-14-pgpool2 - connection pool server and replication proxy for Po= stgreSQL - modules postgresql-14-pgq-node - Cascaded queueing on top of PgQ postgresql-14-pgq3 - Generic queue for PostgreSQL postgresql-14-pgrouting - Routing functionality support for PostgreSQL/Post= GIS postgresql-14-pgrouting-doc - Routing functionality support for PostgreSQL/= PostGIS (Documentation) postgresql-14-pgrouting-scripts - Routing functionality support for Postgre= SQL/PostGIS - SQL scripts postgresql-14-pgsphere - Spherical data types for PostgreSQL postgresql-14-pgtap - Unit testing framework extension for PostgreSQL 14 postgresql-14-pldebugger - PostgreSQL pl/pgsql Debugger API postgresql-14-pllua - Lua procedural language for PostgreSQL 14 postgresql-14-plpgsql-check - plpgsql_check extension for PostgreSQL postgresql-14-plproxy - database partitioning system for PostgreSQL 14 postgresql-14-plr - Procedural language interface between PostgreSQL and R postgresql-14-plsh - PL/sh procedural language for PostgreSQL 14 postgresql-14-pointcloud - PostgreSQL extension for storing point cloud (LI= DAR) data postgresql-14-postgis-3 - Geographic objects support for PostgreSQL 14 postgresql-14-postgis-3-scripts - Geographic objects support for PostgreSQL= 14 -- SQL scripts postgresql-14-powa - PostgreSQL Workload Analyzer -- PostgreSQL 14 extensio= n postgresql-14-prefix - Prefix Range module for PostgreSQL postgresql-14-preprepare - pre prepare your PostgreSQL statements server si= de postgresql-14-prioritize - Get and set the nice priorities of PostgreSQL ba= ckends postgresql-14-q3c - PostgreSQL 14 extension used for indexing the sky postgresql-14-rational - Precise fractional arithmetic for PostgreSQL postgresql-14-rdkit - Cheminformatics and machine-learning software (Postgr= eSQL Cartridge) postgresql-14-repack - reorganize tables in PostgreSQL databases with minim= al locks postgresql-14-repmgr - replication manager for PostgreSQL 14 postgresql-14-rum - PostgreSQL RUM access method postgresql-14-semver - Semantic version number type for PostgreSQL postgresql-14-similarity - PostgreSQL similarity functions extension postgresql-14-slony1-2 - replication system for PostgreSQL: PostgreSQL 14 s= erver plug-in postgresql-14-snakeoil - PostgreSQL anti-virus scanner based on ClamAV postgresql-14-tdigest - t-digest algorithm for on-line accumulation of rank= -based statistics postgresql-14-tds-fdw - PostgreSQL foreign data wrapper for TDS databases postgresql-14-toastinfo - Show storage structure of varlena datatypes in Po= stgreSQL postgresql-14-unit - SI Units for PostgreSQL postgresql-14-wal2json - PostgreSQL logical decoding JSON output plugin postgresql-all - metapackage depending on all PostgreSQL server packages postgresql-autodoc - Utility to create a PostgreSQL database schema overvie= w in HTML, DOT and XML postgresql-comparator - efficient PostgreSQL table content comparison and s= ynchronization postgresql-filedump - Dump PostgreSQL files in human-readable form postgresql-server-dev-14 - development files for PostgreSQL 14 server-side = programming postgresql-server-dev-all - extension build tool for multiple PostgreSQL ve= rsions powa-collector - PoWA collector daemon for remote snapshots wicap@CR-DTAK-HQ:~$=20 There does not seem to be an option to go past version 14. Thanks in advance, V/R, C/M David Hicks. Wireless Infrastructure and Communications - Applied Projects (WICAP)=20 "D" Division Royal Canadian Mounted Police Cell: (204)997-0739 Fax: (204)984-8814 Email: david.j.hicks@rcmp-grc.gc.ca -----Original Message----- From: Christoph Berg =20 Sent: Monday, June 16, 2025 16:39 To: Hicks, David (RCMP/GRC) Cc: pgsql-pkg-debian@postgresql.org Subject: Re: Jammy-pgdg repository Re: Hicks, David (RCMP/GRC) > So I am trying to install Postgresql-15 on Ubuntu 22.04LTS. I have done = all the repository subscription work on my end and I can only see version 1= 4. Hi, 14 is the version shipped with jammy. If apt.postgresql.org doesn't show up= , you missed one step in setting up the repo. (Did you run `apt update`?) Christoph