| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | PopeRigby <poperigby(at)mailbox(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Errors when restoring backup created by pg_dumpall |
| Date: | 2024-11-30 01:44:46 |
| Message-ID: | CANzqJaBBOdEZWD9cwtBZ4Te+T-_bhKj1oM12QT+7MScboxNAGA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 29, 2024 at 8:35 PM PopeRigby <poperigby(at)mailbox(dot)org> wrote:
> 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?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2024-11-30 01:47:55 | Re: Errors when restoring backup created by pg_dumpall |
| Previous Message | PopeRigby | 2024-11-30 01:34:39 | Errors when restoring backup created by pg_dumpall |