Errors when restoring backup created by pg_dumpall

From: PopeRigby <poperigby(at)mailbox(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Errors when restoring backup created by pg_dumpall
Date: 2024-11-30 01:34:39
Message-ID: 6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-11-30 01:44:46 Re: Errors when restoring backup created by pg_dumpall
Previous Message Igor Korot 2024-11-29 20:46:36 Re: Find out the version of the server