---------- Forwarded message --------- From: Gandalf the Gray <[email protected]> Date: Fri, Jan 19, 2024 at 7:39 AM Subject: Re: Postgres segfaults on raster query To: Paul Ramsey <[email protected]>
Hi Paul. I may be completely off base here, but MobilityDB requires you to have postgis in preload. From their github: "You should also set the following in postgresql.conf depending on the version of PostGIS you have installed (below we use PostGIS 3): shared_preload_libraries = 'postgis-3' max_locks_per_transaction = 128 If you do not preload the PostGIS library you will not be able to load the MobilityDB library and will get an error message such as the following one ERROR: could not load library "/usr/local/pgsql/lib/libMobilityDB-1.0.so": undefined symbol: ST_Distance" On Fri, Jan 19, 2024 at 6:26 AM Paul Ramsey <[email protected]> wrote: > This seems… odd to me? In what context is putting postgis into the preload > a requirement? > > P > > > On Jan 18, 2024, at 8:20 PM, Scott <[email protected]> wrote: > > > > Bam! > > > > That was it. Thanks Regina, you rock! > > > > On 1/18/24 20:16, Regina Obe wrote: > >> ALTER SYSTEM SET shared_preload_libraries = 'postgis-3'; > >
