Errors when restoring backup created by pg_dumpall - Mailing list pgsql-general

From PopeRigby
Subject Errors when restoring backup created by pg_dumpall
Date
Msg-id 6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org
Whole thread Raw
Responses Re: Errors when restoring backup created by pg_dumpall
Re: Errors when restoring backup created by pg_dumpall
List 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



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Find out the version of the server
Next
From: Ron Johnson
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall