When you use SET search_path, it applies only to the current session and does not persist across new connections. set search path for user and Database accordingly for example:

ALTER ROLE USER SET search_path TO "$user", public, extensions, gis;