MIME-Version: 1.0
References: <CAPqRbE5Az_XTrGoDRJ3JHwLfOZ6Om26qDFtT2knuOnyPkUkc_A@mail.gmail.com>
In-Reply-To: <CAPqRbE5Az_XTrGoDRJ3JHwLfOZ6Om26qDFtT2knuOnyPkUkc_A@mail.gmail.com>
From: Esteban Zimanyi <estebanzimanyi@gmail.com>
Date: Tue, 10 Oct 2023 10:58:57 +0200
Message-ID: <CAPqRbE7m3+tDCg08e-5xLXW0aUvaadNvfvXMmupS2_jr_jLCFQ@mail.gmail.com>
Subject: Fwd: Advice about preloaded libraries
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ced188060758ec73"
Archived-At: <https://www.postgresql.org/message-id/CAPqRbE7m3%2BtDCg08e-5xLXW0aUvaadNvfvXMmupS2_jr_jLCFQ%40mail.gmail.com>
Precedence: bulk

--000000000000ced188060758ec73
Content-Type: text/plain; charset="UTF-8"

MobilityDB
https://github.com/MobilityDB/MobilityDB
is a PostgreSQL extension that depends on PosGIS.

Bradford Boyle who has been working on packaging MobilityDB
https://www.postgresql.org/message-id/CAPqRbE716D3gpD0JDbaFAb72ELaJrPpG1LUZvobELNBgL3R0+g@mail.gmail.com
highlighted the issue of which of the GUC shared_preload_libraries vs
local_preload_libraries vs session_preload_libraries should be used to load
the postgis-3 library.

Our understanding of the information in the manual
https://www.postgresql.org/docs/16/runtime-config-client.html#GUC-SESSION-PRELOAD-LIBRARIES
does not give us a clear-cut answer for this question. We are looking for
advice on which of the three options mentioned above should be used.

MobilityDB requires loading PostGIS before any MobilityDB query can be
issued. For example, commenting out the following line
#shared_preload_libraries = 'postgis-3'
in the postgresql.conf shows the following

$ psql test
psql (15.3)
Type "help" for help.

test=# select tgeompoint 'Point(1 1)@2000-01-01';
2023-10-03 16:41:25.980 CEST [8683] ERROR:  could not load library
"/usr/local/pgsql/15/lib/libMobilityDB-1.1.so": /usr/local/pgsql/15/lib/
libMobilityDB-1.1.so: undefined symbol: ST_Intersects at character 19
2023-10-03 16:41:25.980 CEST [8683] STATEMENT:  select tgeompoint 'Point(1
1)@2000-01-01';
ERROR:  could not load library "/usr/local/pgsql/15/lib/libMobilityDB-1.1.so":
/usr/local/pgsql/15/lib/libMobilityDB-1.1.so: undefined symbol:
ST_Intersects
LINE 1: select tgeompoint 'Point(1 1)@2000-01-01';
                          ^
test=# select st_point(1,1);
                  st_point
--------------------------------------------
 0101000000000000000000F03F000000000000F03F
(1 row)

test=# select tgeompoint 'Point(1 1)@2000-01-01';
                            tgeompoint
-------------------------------------------------------------------
 0101000000000000000000F03F000000000000F03F@2000-01-01 00:00:00+01
(1 row)

test=#
------------------------------------------------------------

As can be seen above, it is not REALLY mandatory to have
shared_preload_libraries = 'postgis-3' but then the user is responsible for
issuing a query to load PostGIS (select st_point(1,1); above) and then she
is able to execute MobilityDB queries.

Thanks for your advice.

--000000000000ced188060758ec73
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">MobilityDB<br><a href=3D"https://github.com/MobilityDB/Mob=
ilityDB">https://github.com/MobilityDB/MobilityDB</a><br>is a PostgreSQL ex=
tension that depends on PosGIS.<br><br>Bradford Boyle who has been working =
on packaging MobilityDB<br><a href=3D"https://www.postgresql.org/message-id=
/CAPqRbE716D3gpD0JDbaFAb72ELaJrPpG1LUZvobELNBgL3R0+g@mail.gmail.com">https:=
//www.postgresql.org/message-id/CAPqRbE716D3gpD0JDbaFAb72ELaJrPpG1LUZvobELN=
BgL3R0+g@mail.gmail.com</a><br>highlighted the issue of which of the GUC sh=
ared_preload_libraries vs local_preload_libraries vs session_preload_librar=
ies should be used to load the postgis-3 library.<br><br>Our understanding =
of the information in the manual<br><a href=3D"https://www.postgresql.org/d=
ocs/16/runtime-config-client.html#GUC-SESSION-PRELOAD-LIBRARIES">https://ww=
w.postgresql.org/docs/16/runtime-config-client.html#GUC-SESSION-PRELOAD-LIB=
RARIES</a><br>does not give us a clear-cut answer for this question. We are=
 looking for advice on which of the three options mentioned above should be=
 used.<br><br>MobilityDB requires loading PostGIS before any MobilityDB que=
ry can be issued. For example, commenting out the following line<br>#shared=
_preload_libraries =3D &#39;postgis-3&#39;<br>in the postgresql.conf shows =
the following<br><br>$ psql test<br>psql (15.3)<br>Type &quot;help&quot; fo=
r help.<br><br>test=3D# select tgeompoint &#39;Point(1 1)@2000-01-01&#39;;<=
br>2023-10-03 16:41:25.980 CEST [8683] ERROR: =C2=A0could not load library =
&quot;/usr/local/pgsql/15/lib/<a href=3D"http://libMobilityDB-1.1.so">libMo=
bilityDB-1.1.so</a>&quot;: /usr/local/pgsql/15/lib/<a href=3D"http://libMob=
ilityDB-1.1.so">libMobilityDB-1.1.so</a>: undefined symbol: ST_Intersects a=
t character 19<br>2023-10-03 16:41:25.980 CEST [8683] STATEMENT: =C2=A0sele=
ct tgeompoint &#39;Point(1 1)@2000-01-01&#39;;<br>ERROR: =C2=A0could not lo=
ad library &quot;/usr/local/pgsql/15/lib/<a href=3D"http://libMobilityDB-1.=
1.so">libMobilityDB-1.1.so</a>&quot;: /usr/local/pgsql/15/lib/<a href=3D"ht=
tp://libMobilityDB-1.1.so">libMobilityDB-1.1.so</a>: undefined symbol: ST_I=
ntersects<br>LINE 1: select tgeompoint &#39;Point(1 1)@2000-01-01&#39;;<br>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 ^<br>test=3D# select st_point(1,1);<br>=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 st_point<br>-----------------=
---------------------------<br>=C2=A00101000000000000000000F03F000000000000=
F03F<br>(1 row)<br><br>test=3D# select tgeompoint &#39;Point(1 1)@2000-01-0=
1&#39;;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 tgeompoint<br>--------------------------=
-----------------------------------------<br>=C2=A00101000000000000000000F0=
3F000000000000F03F@2000-01-01 00:00:00+01<br>(1 row)<br><br>test=3D#<br>---=
---------------------------------------------------------<br><br>As can be =
seen above, it is not REALLY mandatory to have shared_preload_libraries =3D=
 &#39;postgis-3&#39; but then the user is responsible for issuing a query t=
o load PostGIS (select st_point(1,1); above) and then she is able to execut=
e MobilityDB queries.<br><br>Thanks for your advice.<br><br></div>

--000000000000ced188060758ec73--