[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: How do I correctly relocate PostGIS control files?
From: |
Gary Johnson |
Subject: |
Re: How do I correctly relocate PostGIS control files? |
Date: |
Tue, 03 Nov 2020 19:38:26 -0500 |
Julien Lepiller <julien@lepiller.eu> 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-postgresql-13.0
gjohnson@euclid ~ $ ls
/gnu/store/8m48v5132qpmxim9s4g9vca59qgay2d9-postgresql-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_statements--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_statements--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_statements--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_statements--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_statements--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_statements--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_statements--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_statements--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_statements--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_statements.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.control
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_visibility--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_visibility--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_visibility--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.sql
moddatetime.control pg_prewarm--1.1.sql
pg_visibility.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
> postgis package itself?
gjohnson@euclid ~ $ tree
/gnu/store/0cb4sf18w2i9f0b79kyrli7fx3i63c4s-postgis-3.0.2
/gnu/store/0cb4sf18w2i9f0b79kyrli7fx3i63c4s-postgis-3.0.2
├── bin
│ ├── pgsql2shp
│ ├── raster2pgsql
│ └── shp2pgsql
├── lib
│ ├── address_standardizer-3.so
│ ├── postgis-3.so
│ ├── postgis_raster-3.so
│ └── postgis_topology-3.so
└── share
├── contrib
├── doc
└── extension
├── address_standardizer.control
├── address_standardizer_data_us.control
├── postgis.control
├── postgis_raster.control
├── postgis_tiger_geocoder.control
├── postgis_topology.control
├── ...
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
--
GPG Key ID: 7BC158ED
Use `gpg --search-keys lambdatronic' to find me
Protect yourself from surveillance: https://emailselfdefense.fsf.org
=======================================================================
() 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