Postgres segfaults on raster query

[Regina Obe]

> 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();