On Saturday, November 30, 2024, PopeRigby <
poperigby@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.
