Errors when restoring backup created by pg_dumpall

PopeRigby <poperigby@mailbox.org>

From: PopeRigby <poperigby@mailbox.org>
To: pgsql-general@postgresql.org
Date: 2024-11-30T01:34:39Z
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



Commits

  1. contrib/earthdistance: Use SQL-standard function bodies.