MIME-Version: 1.0
References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org>
In-Reply-To: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 29 Nov 2024 20:44:46 -0500
Message-ID: <CANzqJaBBOdEZWD9cwtBZ4Te+T-_bhKj1oM12QT+7MScboxNAGA@mail.gmail.com>
Subject: Re: Errors when restoring backup created by pg_dumpall
To: PopeRigby <poperigby@mailbox.org>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000073c69e06281776e9"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBBOdEZWD9cwtBZ4Te%2BT-_bhKj1oM12QT%2B7MScboxNAGA%40mail.gmail.com>
Precedence: bulk

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

On Fri, Nov 29, 2024 at 8:35=E2=80=AFPM PopeRigby <poperigby@mailbox.org> w=
rote:

> My HDD recently failed so I'm trying to restore my backup, but I'm
> running into some errors.
>
> I've been using a systemd service that periodically backs up my cluster
> with pg_dumpall, and I'm using this command to restore:
>
> sudo psql -f backup.sql postgres
>
> I'm getting this output:
> https://gist.github.com/poperigby/d5a0103b9de1eba95aba783007e557ea
>
> This is my (redacted) database dump:
> https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49
>

Have you installed whatever software provides extensions like cube, vector
and earthdistance?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Nov 29, 2024 at 8:35=E2=80=AFPM P=
opeRigby &lt;<a href=3D"mailto:poperigby@mailbox.org">poperigby@mailbox.org=
</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex">My HDD recently failed so I&#39;m trying to restore =
my backup, but I&#39;m <br>
running into some errors.<br>
<br>
I&#39;ve been using a systemd service that periodically backs up my cluster=
 <br>
with pg_dumpall, and I&#39;m using this command to restore:<br>
<br>
sudo psql -f backup.sql postgres<br>
<br>
I&#39;m getting this output: <br>
<a href=3D"https://gist.github.com/poperigby/d5a0103b9de1eba95aba783007e557=
ea" rel=3D"noreferrer" target=3D"_blank">https://gist.github.com/poperigby/=
d5a0103b9de1eba95aba783007e557ea</a><br>
<br>
This is my (redacted) database dump: <br>
<a href=3D"https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b=
49" rel=3D"noreferrer" target=3D"_blank">https://gist.github.com/poperigby/=
fcb59eb6c22c6051800e06a0ec482b49</a><br></blockquote><div><br></div><div>Ha=
ve you installed whatever software provides extensions like cube, vector an=
d earthdistance?</div><div><br></div></div><span class=3D"gmail_signature_p=
refix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D=
"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I=
&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div=
></div></div></div>

--00000000000073c69e06281776e9--