Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mGlhZ-0000zH-7I for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 19 Aug 2021 17:19:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mGlhY-0005OS-5C for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 19 Aug 2021 17:19:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mGlhX-0005La-WF for pgsql-pkg-debian@lists.postgresql.org; Thu, 19 Aug 2021 17:19:36 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mGlhV-0003eV-0W for pgsql-pkg-debian@lists.postgresql.org; Thu, 19 Aug 2021 17:19:34 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1478:c9c0:a79c:ae6d:664a:fae8]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature ECDSA (P-384) server-digest SHA384) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 4GrBMl05r3z3Dws; Thu, 19 Aug 2021 19:19:30 +0200 (CEST) Date: Thu, 19 Aug 2021 19:19:30 +0200 From: Christoph Berg To: Christophe Courtois Cc: pgsql-pkg-debian@lists.postgresql.org Subject: Re: PostGIS 2.5 for PostgreSQL 14 or Debian 11 ? Message-ID: References: <9b75a117-9b80-9404-7009-c4f341784b8a@dalibo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9b75a117-9b80-9404-7009-c4f341784b8a@dalibo.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Re: Christophe Courtois > 1) On Ubuntu 20.04 or Debian 10, the following packages do exist: > > postgresql-13-postgis-2.5 > postgresql-13-postgis-3 > postgresql-14-postgis-3 > > But I cannot found PostGIS 2.5 for PG 14. > > Is PostGIS 2.5 already deprecated? > > (If I understand, it was not supported for PG13 [1], > but the package does exist.) Hi, yes 2.5 is deprecated. I got it working for PG13 to help people upgrading. I do not plan to repeat that tour de force again. (There were lots of minor problems to ignore on the way.) > 2) PostGIS 2.5 does not seem available on Debian 11, whatever the PG > version. > I suppose there is some dependency issue. Debian 11 is new, please use postgis 3 for new setups, or upgrade postgis first. > All the documentation that I found deals with older versions, so I just > ask. 2.5 postgis on PG14 would be useful for some migrations. Please upgrade to postgis 3 on the old PG version first (or migrate both PG and postgis at the same time). Christoph