Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tHCNu-004Zd2-1Z
	for pgsql-general@arkaria.postgresql.org; Sat, 30 Nov 2024 01:34:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tHCNq-00C0lF-FZ
	for pgsql-general@arkaria.postgresql.org; Sat, 30 Nov 2024 01:34:55 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <poperigby@mailbox.org>)
	id 1tHCNp-00C0l3-9s
	for pgsql-general@lists.postgresql.org; Sat, 30 Nov 2024 01:34:55 +0000
Received: from mout-p-201.mailbox.org ([2001:67c:2050:0:465::201])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <poperigby@mailbox.org>)
	id 1tHCNj-000EmF-0U
	for pgsql-general@postgresql.org; Sat, 30 Nov 2024 01:34:53 +0000
Received: from smtp1.mailbox.org (smtp1.mailbox.org [IPv6:2001:67c:2050:b231:465::1])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256)
	(No client certificate requested)
	by mout-p-201.mailbox.org (Postfix) with ESMTPS id 4Y0XfC0Zkjz9stY
	for <pgsql-general@postgresql.org>; Sat, 30 Nov 2024 02:34:43 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailbox.org; s=mail20150812;
	t=1732930483;
	h=from:from:reply-to:subject:subject:date:date:message-id:message-id:
	 to:to:cc:mime-version:mime-version:content-type:content-type:
	 content-transfer-encoding:content-transfer-encoding;
	bh=IKU9P5G6inddOrxQXY46CvE7UoJXK22Z+/U9a2xXdNQ=;
	b=TmS6rn2I0HEVvE/ZPK4GP7uVObpBmYwILqWnSYD6/XJBxUTFHfRs189r8gEoeLZUBpKQUr
	3IGwbPQISpTRBICV+h2vM9uc1LaA8O7fHegeRWQAns1E4roaxHxeSEhTXPR794UBftPja2
	G3A6HV0vG3jVUSSvQL9NaatbHR0vdZf9IU2joXNWr5wo6Ux87BuuHVJlGN6GofShVUnxQo
	IctJ08bHfwH7rs+6+uboGKHjcKuzEj+EYzaPunkSWSdbcoQfwBKeRQNesdLp/JfC6IY4B7
	WkjdAhltWGbnrJisdrxvj7S8jBXKEN6aYSQfrlvLfyv2Hp+jPoEs+EsYa/gVCw==
Message-ID: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org>
Date: Fri, 29 Nov 2024 17:34:39 -0800
MIME-Version: 1.0
Content-Language: en-US
To: pgsql-general@postgresql.org
From: PopeRigby <poperigby@mailbox.org>
Subject: Errors when restoring backup created by pg_dumpall
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-MBO-RS-META: 6yi53c9b4x7qjbeqs3ywmnws361eopxn
X-MBO-RS-ID: f0e5fe3300120e420e8
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/6a6439f1-8039-44e2-8fb9-59028f7f2014%40mailbox.org>
Precedence: bulk

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