Search Postgresql Archives

Re: Errors when restoring backup created by pg_dumpall

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux