On Saturday, November 30, 2024, PopeRigby <poperi...@mailbox.org> wrote:
> > Ok, so the error is not emanating from your code but rather the body of > the ll_to_earth function defined in the earthdistance extension. > > David J. > > By code do you mean my sql file created by pg_dumpall? Sorry, I'm just a > self-hoster so I'm not very well versed in Postgres. I'm just trying to get > my server back online. > Yes, your “code” is the user contents of the SQL file. Your best bet is probably to locate the various “set_config(‘search_path’, ‘’)” commands and add “public” to them. Since you installed earthdistance to public this should bridge the gap. David J.