Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUrjx-0002tt-OE for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 13 Nov 2019 12:27:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iUrjv-00024f-4q for pgsql-pkg-debian@arkaria.postgresql.org; Wed, 13 Nov 2019 12:27:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUrju-00024Y-RM for pgsql-pkg-debian@lists.postgresql.org; Wed, 13 Nov 2019 12:27:14 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iUrjr-0007M0-3U for pgsql-pkg-debian@lists.postgresql.org; Wed, 13 Nov 2019 12:27:13 +0000 Received: from msg.df7cb.de (185-232-103-115.xdsl.philuweb.net [185.232.103.115]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 47CkQ40gkRz3F07; Wed, 13 Nov 2019 13:27:08 +0100 (CET) Date: Wed, 13 Nov 2019 13:27:07 +0100 From: Christoph Berg To: Michael =?iso-8859-1?Q?B=F6hm?= Cc: pgsql-pkg-debian@lists.postgresql.org Subject: Re: postgis update from 2.5 to 3 Message-ID: <20191113122707.GB3741@msg.df7cb.de> References: <20191112143958.GC20731@msg.df7cb.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: Michael Böhm 2019-11-13 > > Interesting... I would have thought that upgrading didn't need the old > > files. > > > > Well it looked like this: > > edugis=# SELECT PostGIS_full_version(); > FEHLER: konnte nicht auf Datei »$libdir/postgis-2.5« zugreifen: Datei oder > Verzeichnis nicht gefunden > KONTEXT: SQL-Anweisung »SELECT public.postgis_lib_version()« > PL/pgSQL-Funktion postgis_full_version() Zeile 26 bei SQL-Anweisung Ok, that's missing the old *libs*, that's somewhat expected. > > Which versions of the -2.5 and -3 packages exactly did you use? > > > > Well i always try to update asap so before i had: > ii postgresql-10-postgis-2.5 2.5.3+dfsg-2.pgdg100+1 > ii postgresql-10-postgis-2.5-scripts 2.5.3+dfsg-2.pgdg100+1 > and now > ii postgresql-10-postgis-3 3.0.0+dfsg-2~exp1.pgdg100+1 > ii postgresql-10-postgis-3-scripts 3.0.0+dfsg-2~exp1.pgdg100+1 Thanks, I'll see what I can do about the file conflicts. It will likely take until next week, however. Christoph