MIME-Version: 1.0
References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org>
 <cba48d2c-0987-4233-a86f-2e693677efd3@aklaver.com> <9c5ba566-27b8-4e8c-bf7d-2dc561509991@mailbox.org>
 <CAKFQuwaB5GuUNuyiUbS0ah-LYXepHLPnOHrP7g8RMz8ywOm3zQ@mail.gmail.com>
 <ff94f628-27af-4c3a-9590-cba38bb5d2d1@mailbox.org> <CAKFQuwYQUequkYVS8SLgC1L0TOdWNK=xVyxnPD9RPPwfvYRFSQ@mail.gmail.com>
 <41791b6d-aaf5-4fed-9cc3-e89bc49e8637@mailbox.org> <CAKFQuwbe4TSU_LxsrGxgcv4DfQq2x-UNoyKx-ABy36PhvbGCdg@mail.gmail.com>
 <1257068.1733025493@sss.pgh.pa.us> <06425038-e012-4bac-aec1-d9541436f893@mailbox.org>
 <92405f98-7f0c-4442-8252-697352daefc1@aklaver.com> <1470486.1733087658@sss.pgh.pa.us>
 <4ab662d8-57cc-471f-8a58-cfd71d1cea22@aklaver.com> <1475512.1733090108@sss.pgh.pa.us>
 <19d5f2c7-1252-4442-accb-8aa2cb289ad0@mailbox.org> <CANzqJaCAtmhvXfE-5--Pzk4Wr=9q+C=d8jiVj-Zm=aNnZMCwNg@mail.gmail.com>
In-Reply-To: <CANzqJaCAtmhvXfE-5--Pzk4Wr=9q+C=d8jiVj-Zm=aNnZMCwNg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 5 Dec 2024 16:23:49 -0700
Message-ID: <CAKFQuwaXsgZncO10khobrdC=_NLxBWQX4XQEuVVCfouqqrnLHA@mail.gmail.com>
Subject: Re: Errors when restoring backup created by pg_dumpall
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fec42a06288e3232"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaXsgZncO10khobrdC%3D_NLxBWQX4XQEuVVCfouqqrnLHA%40mail.gmail.com>
Precedence: bulk

--000000000000fec42a06288e3232
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Dec 5, 2024 at 4:04=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com=
> wrote:

> Another alternative is to open the .sql file in Notepad++, then add
> "public." before all the unqualified "earth" and "ll_to_earth" references=
.
>

And as discussed there are none in that file because those references are
within an extension's objects and only create extension appears in the file=
.

David J.

--000000000000fec42a06288e3232
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Thu, Dec 5, 2024 at 4:04=E2=80=AFPM Ron Johnson &lt;<a =
href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wro=
te:</span></div></div><div class=3D"gmail_quote gmail_quote_container"><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=
=3D"gmail_quote"><div>Another alternative is to open the .sql file in Notep=
ad++, then add &quot;public.&quot; before all the unqualified &quot;earth&q=
uot; and &quot;ll_to_earth&quot; references.</div></div></div></blockquote>=
<div><br></div><div class=3D"gmail_default" style=3D"font-family:arial,helv=
etica,sans-serif">And as discussed there are none in that file because thos=
e references are within an extension&#39;s objects and only create extensio=
n appears in the file.</div><div class=3D"gmail_default" style=3D"font-fami=
ly:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div></di=
v></div>

--000000000000fec42a06288e3232--