From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 2NfzAxIFol8DUgAA0tVLHw (envelope-from ) for ; Wed, 04 Nov 2020 01:34:10 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id MAzoOhEFol9vVAAAbx9fmQ (envelope-from ) for ; Wed, 04 Nov 2020 01:34:09 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 313669403D3 for ; Wed, 4 Nov 2020 01:34:09 +0000 (UTC) Received: from localhost ([::1]:34026 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ka7gc-0003F8-0f for larch@yhetil.org; Tue, 03 Nov 2020 20:34:06 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:36398) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ka6pD-0000xi-4h for help-guix@gnu.org; Tue, 03 Nov 2020 19:38:56 -0500 Received: from knopi.disroot.org ([178.21.23.139]:40788) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ka6pA-000550-Bn for help-guix@gnu.org; Tue, 03 Nov 2020 19:38:54 -0500 Received: from localhost (localhost [127.0.0.1]) by disroot.org (Postfix) with ESMTP id 23EE2522C1; Wed, 4 Nov 2020 01:38:47 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at disroot.org Received: from knopi.disroot.org ([127.0.0.1]) by localhost (disroot.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id TxWYW9YyJ6eV; Wed, 4 Nov 2020 01:38:45 +0100 (CET) References: <87y2jjgz7a.fsf@disroot.org> <58ED72A6-E00F-4E9F-A111-6E4C082212D3@lepiller.eu> DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=disroot.org; s=mail; t=1604450325; bh=A8XTFGbvKuqexcCVwEXlurKsGWQoT2B7W7shEGgNJfk=; h=References:From:To:Cc:Subject:In-reply-to:Date; b=UqwIF1Vfh/nfIGeNfMlupbE4/qp4rcGlt5tLaIsQ2LjD/sa3oAgjZQFwyz0P6pDB+ 2XAGANyyDYysmAHTbst/997+0JGHoDWgP7qAo80tal65S3cZ83E0wP6DvT938jzQha cpxIt9EdELs2bZoiCDfHZdeWJGb8rbMjeJUetfNf9qm+oYPieX4SyCxpMrGiYjEUR8 eW3KoMOwq1W2HDH2g7FS2JzXvUocnDSwEjtvzNJ9iv5anei7fDKOhHImZG1bhMn0P6 /9CpCAzYn0g4vpokDTR2ThXcmDPnJctJk6RY4vlmIHi5ztmTEnwtTHB4wKj8Oi5v7/ i7exiQR0+YruQ== From: Gary Johnson To: Julien Lepiller Cc: help-guix Subject: Re: How do I correctly relocate PostGIS control files? In-reply-to: <58ED72A6-E00F-4E9F-A111-6E4C082212D3@lepiller.eu> Date: Tue, 03 Nov 2020 19:38:26 -0500 Message-ID: <87k0v2ez25.fsf@disroot.org> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=178.21.23.139; envelope-from=lambdatronic@disroot.org; helo=knopi.disroot.org X-detected-operating-system: by eggs.gnu.org: First seen = 2020/11/03 19:38:47 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-guix@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-guix-bounces+larch=yhetil.org@gnu.org Sender: "Help-Guix" X-Scanner: ns3122888.ip-94-23-21.eu Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=disroot.org header.s=mail header.b=UqwIF1Vf; dmarc=pass (policy=quarantine) header.from=disroot.org; spf=pass (aspmx1.migadu.com: domain of help-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=help-guix-bounces@gnu.org X-Spam-Score: -0.21 X-TUID: 3CqD2Rva5ItB Julien Lepiller writes: > The service simply builds a union-build of the postgis and postgresql > packages, because postgresql looks for its extensions in the directory > it's run from. > > It could be that this behavior changed, or that the postgis package > doesn't build its extension as expected. > > To cgeck these hypothesis: can you check the error message contains > the store path of the union (as opposed to only postresql). You should > be able to find some of postgis files there in addition to postgresql > files. gjohnson@euclid ~ $ guix package -p /run/current-system/profile -I ... postgis 3.0.2 out /gnu/store/0cb4sf18w2i9f0b79kyrli7fx3i63c4s-postgis= -3.0.2 postgresql 13.0 out /gnu/store/8m48v5132qpmxim9s4g9vca59qgay2d9-postgre= sql-13.0 gjohnson@euclid ~ $ ls /gnu/store/8m48v5132qpmxim9s4g9vca59qgay2d9-postgres= ql-13.0/share/extension/ adminpack--1.0--1.1.sql btree_gist--1.3--1.4.sql dict_int.control = intagg--1.0--1.1.sql pageinspect--1.1--1.2.sql pg_stat_sta= tements--1.0--1.1.sql pgcrypto--1.1--1.2.sql seg--1.1--1.2.sql adminpack--1.0.sql btree_gist--1.4--1.5.sql dict_xsyn--1.0.sql = intagg--1.1.sql pageinspect--1.2--1.3.sql pg_stat_sta= tements--1.1--1.2.sql pgcrypto--1.2--1.3.sql seg--1.1.sql adminpack--1.1--2.0.sql btree_gist.control dict_xsyn.control = intagg.control pageinspect--1.3--1.4.sql pg_stat_sta= tements--1.2--1.3.sql pgcrypto--1.3.sql seg--1.2--1.3.sql adminpack--2.0--2.1.sql citext--1.0--1.1.sql earthdistance--1.0--1.1= .sql intarray--1.0--1.1.sql pageinspect--1.4--1.5.sql pg_stat_sta= tements--1.3--1.4.sql pgcrypto.control seg.control adminpack.control citext--1.1--1.2.sql earthdistance--1.1.sql = intarray--1.1--1.2.sql pageinspect--1.5--1.6.sql pg_stat_sta= tements--1.4--1.5.sql pgrowlocks--1.0--1.1.sql sslinfo--1.0--1.1.sql amcheck--1.0--1.1.sql citext--1.2--1.3.sql earthdistance.control = intarray--1.2--1.3.sql pageinspect--1.5.sql pg_stat_sta= tements--1.4.sql pgrowlocks--1.1--1.2.sql sslinfo--1.1--1.2.sql amcheck--1.0.sql citext--1.3--1.4.sql file_fdw--1.0.sql = intarray--1.2.sql pageinspect--1.6--1.7.sql pg_stat_sta= tements--1.5--1.6.sql pgrowlocks--1.2.sql sslinfo--1.2.sql amcheck--1.1--1.2.sql citext--1.4--1.5.sql file_fdw.control = intarray.control pageinspect--1.7--1.8.sql pg_stat_sta= tements--1.6--1.7.sql pgrowlocks.control sslinfo.control amcheck.control citext--1.4.sql fuzzystrmatch--1.0--1.1= .sql isn--1.0--1.1.sql pageinspect.control pg_stat_sta= tements--1.7--1.8.sql pgstattuple--1.0--1.1.sql tablefunc--1.0.sql autoinc--1.0.sql citext--1.5--1.6.sql fuzzystrmatch--1.1.sql = isn--1.1--1.2.sql pg_buffercache--1.0--1.1.sql pg_stat_sta= tements.control pgstattuple--1.1--1.2.sql tablefunc.control autoinc.control citext.control fuzzystrmatch.control = isn--1.1.sql pg_buffercache--1.1--1.2.sql pg_trgm--1.= 0--1.1.sql pgstattuple--1.2--1.3.sql tcn--1.0.sql bloom--1.0.sql cube--1.0--1.1.sql hstore--1.0--1.1.sql = isn.control pg_buffercache--1.2--1.3.sql pg_trgm--1.= 1--1.2.sql pgstattuple--1.3--1.4.sql tcn.control bloom.control cube--1.1--1.2.sql hstore--1.1--1.2.sql = lo--1.0--1.1.sql pg_buffercache--1.2.sql pg_trgm--1.= 2--1.3.sql pgstattuple--1.4--1.5.sql tsm_system_rows--1.0.sql btree_gin--1.0--1.1.sql cube--1.2--1.3.sql hstore--1.2--1.3.sql = lo--1.1.sql pg_buffercache.control pg_trgm--1.= 3--1.4.sql pgstattuple--1.4.sql tsm_system_rows.control btree_gin--1.0.sql cube--1.2.sql hstore--1.3--1.4.sql = lo.control pg_freespacemap--1.0--1.1.sql pg_trgm--1.= 3.sql pgstattuple.control tsm_system_time--1.0.sql btree_gin--1.1--1.2.sql cube--1.3--1.4.sql hstore--1.4--1.5.sql = ltree--1.0--1.1.sql pg_freespacemap--1.1--1.2.sql pg_trgm--1.= 4--1.5.sql plpgsql--1.0.sql tsm_system_time.control btree_gin--1.2--1.3.sql cube.control hstore--1.4.sql = ltree--1.1--1.2.sql pg_freespacemap--1.1.sql pg_trgm.con= trol plpgsql.control unaccent--1.0--1.1.sql btree_gin.control dblink--1.0--1.1.sql hstore--1.5--1.6.sql = ltree--1.1.sql pg_freespacemap.control pg_visibili= ty--1.0--1.1.sql postgres_fdw--1.0.sql unaccent--1.1.sql btree_gist--1.0--1.1.sql dblink--1.1--1.2.sql hstore--1.6--1.7.sql = ltree.control pg_prewarm--1.0--1.1.sql pg_visibili= ty--1.1--1.2.sql postgres_fdw.control unaccent.control btree_gist--1.1--1.2.sql dblink--1.2.sql hstore.control = moddatetime--1.0.sql pg_prewarm--1.1--1.2.sql pg_visibili= ty--1.1.sql refint--1.0.sql uuid-ossp--1.0--1.1.sql btree_gist--1.2--1.3.sql dblink.control insert_username--1.0.sq= l moddatetime.control pg_prewarm--1.1.sql pg_visibili= ty.control refint.control uuid-ossp--1.1.sql btree_gist--1.2.sql dict_int--1.0.sql insert_username.control= pageinspect--1.0--1.1.sql pg_prewarm.control pgcrypto--1= .0--1.1.sql seg--1.0--1.1.sql uuid-ossp.control So...unfortunately there are no postgis files in the postgresql directory. > For the second hypothesis, can you find the postgis.control file in the p= ostgis package itself? gjohnson@euclid ~ $ tree /gnu/store/0cb4sf18w2i9f0b79kyrli7fx3i63c4s-postgi= s-3.0.2 /gnu/store/0cb4sf18w2i9f0b79kyrli7fx3i63c4s-postgis-3.0.2 =E2=94=9C=E2=94=80=E2=94=80 bin =E2=94=82=C2=A0=C2=A0 =E2=94=9C=E2=94=80=E2=94=80 pgsql2shp =E2=94=82=C2=A0=C2=A0 =E2=94=9C=E2=94=80=E2=94=80 raster2pgsql =E2=94=82=C2=A0=C2=A0 =E2=94=94=E2=94=80=E2=94=80 shp2pgsql =E2=94=9C=E2=94=80=E2=94=80 lib =E2=94=82=C2=A0=C2=A0 =E2=94=9C=E2=94=80=E2=94=80 address_standardizer-3.so =E2=94=82=C2=A0=C2=A0 =E2=94=9C=E2=94=80=E2=94=80 postgis-3.so =E2=94=82=C2=A0=C2=A0 =E2=94=9C=E2=94=80=E2=94=80 postgis_raster-3.so =E2=94=82=C2=A0=C2=A0 =E2=94=94=E2=94=80=E2=94=80 postgis_topology-3.so =E2=94=94=E2=94=80=E2=94=80 share =E2=94=9C=E2=94=80=E2=94=80 contrib =E2=94=9C=E2=94=80=E2=94=80 doc =E2=94=94=E2=94=80=E2=94=80 extension =E2=94=9C=E2=94=80=E2=94=80 address_standardizer.control =E2=94=9C=E2=94=80=E2=94=80 address_standardizer_data_us.control =E2=94=9C=E2=94=80=E2=94=80 postgis.control =E2=94=9C=E2=94=80=E2=94=80 postgis_raster.control =E2=94=9C=E2=94=80=E2=94=80 postgis_tiger_geocoder.control =E2=94=9C=E2=94=80=E2=94=80 postgis_topology.control =E2=94=9C=E2=94=80=E2=94=80 ... Yes. All of the expected postgis files can be found in the postgis package. So it looks like there is an issue with the way postgresql-service-type installs its extensions. How can we correct this? Thanks in advance, Gary --=20 GPG Key ID: 7BC158ED Use `gpg --search-keys lambdatronic' to find me Protect yourself from surveillance: https://emailselfdefense.fsf.org =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D () ascii ribbon campaign - against html e-mail /\ www.asciiribbon.org - against proprietary attachments Please avoid sending me MS-Office attachments. See http://www.gnu.org/philosophy/no-word-attachments.html