> Here's what's happening:
>
> psql -d mydb
>
> select rid from rastertable where rid = 1;
>
> Psql connection drops, postgres segfaults and restarts.
>
> BUT, if I do a query such as this FIRST:
>
> select postgis_full_version();
>
> Then do other raster queries, it works fine. I suspect I broke something but
> I'm
> not sure where to start.
>
> Thanks for any help.
> Scott
What other extensions do you have loaded.
Also what does your output return for
SELECT postgis_full_version();
Only thing I can think of is calling postgis_full_version() is causing the
raster and postgis extensions to preload,
I'd check to see if you have anything in
SHOW shared_preload_libraries;
You might actually want to try doing something like:
ALTER SYSTEM SET shared_preload_libraries = 'postgis-3';
And then restart your service to see if it has the same effect as the SELECT
postgis_full_version();
