Re: Errors when restoring backup created by pg_dumpall

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: PopeRigby <poperigby(at)mailbox(dot)org>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Errors when restoring backup created by pg_dumpall
Date: 2024-12-01 03:51:40
Message-ID: CAKFQuwYsUJtQGM09Y3Pb5ycGiCSpX0d_gda6CF88muBJCRcDMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, November 30, 2024, PopeRigby <poperigby(at)mailbox(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-12-01 03:58:13 Re: Errors when restoring backup created by pg_dumpall
Previous Message PopeRigby 2024-12-01 03:47:55 Re: Errors when restoring backup created by pg_dumpall