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-admin-owner+archive@lists.postgresql.org>)
	id 1sNgac-00A0p2-Iu
	for pgsql-admin@arkaria.postgresql.org; Sat, 29 Jun 2024 22:30:38 +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-admin-owner+archive@lists.postgresql.org>)
	id 1sNgaa-00AvXc-Fu
	for pgsql-admin@arkaria.postgresql.org; Sat, 29 Jun 2024 22:30:36 +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 <scott_ribe@elevated-dev.com>)
	id 1sNgaa-00AvXU-1x
	for pgsql-admin@lists.postgresql.org; Sat, 29 Jun 2024 22:30:36 +0000
Received: from mailout.easymail.ca ([64.68.200.34])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1sNgaS-004CxH-Qd
	for pgsql-admin@lists.postgresql.org; Sat, 29 Jun 2024 22:30:35 +0000
Received: from localhost (localhost [127.0.0.1])
	by mailout.easymail.ca (Postfix) with ESMTP id 97D4961166;
	Sat, 29 Jun 2024 22:30:26 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1719700226;
	bh=k+KAlz1RxcgiWyoC2OkW8e65djhpYJd6i5hjE2qbi8E=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=cu51s+LyYBirYjkeZ7E7EQExo0tXAKQqOeoBOrTpgU1rld98TIBhd/ChBY2Rp9ObL
	 BfAjxvWSC27OsqpXVigyPrJ0vUAxxk0OtPI/vvYenQTRk9r9/fVNIbSHxHJBYlGuWx
	 gGeeANcP08DIgtkMxbL+Dsl/QLyrcT2Y0Um1wk6sV+lSCOddKFeSHC6s83mJITfkA7
	 3ZLLlSKM5Z6bEzCh41oQWNtQJCHGdHMnzTiMI4nHMsce/1nQQu+ofj/BwT3GcvjQF8
	 2ywRzGGxzRyts0vHgaMuZk0/TXrF7J0Ba7eep1bBNUGt4knFG/Utz3LEGWmxxuS9uH
	 pFCV92EjCGeww==
X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn
Received: from mailout.easymail.ca ([127.0.0.1])
	by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id cntaYEbl02pY; Sat, 29 Jun 2024 22:30:26 +0000 (UTC)
Received: from smtpclient.apple (unknown [165.140.184.195])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by mailout.easymail.ca (Postfix) with ESMTPSA id 141C56114E;
	Sat, 29 Jun 2024 22:30:26 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1719700226;
	bh=k+KAlz1RxcgiWyoC2OkW8e65djhpYJd6i5hjE2qbi8E=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=cu51s+LyYBirYjkeZ7E7EQExo0tXAKQqOeoBOrTpgU1rld98TIBhd/ChBY2Rp9ObL
	 BfAjxvWSC27OsqpXVigyPrJ0vUAxxk0OtPI/vvYenQTRk9r9/fVNIbSHxHJBYlGuWx
	 gGeeANcP08DIgtkMxbL+Dsl/QLyrcT2Y0Um1wk6sV+lSCOddKFeSHC6s83mJITfkA7
	 3ZLLlSKM5Z6bEzCh41oQWNtQJCHGdHMnzTiMI4nHMsce/1nQQu+ofj/BwT3GcvjQF8
	 2ywRzGGxzRyts0vHgaMuZk0/TXrF7J0Ba7eep1bBNUGt4knFG/Utz3LEGWmxxuS9uH
	 pFCV92EjCGeww==
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Strange "permission denied" errors on pg_restore
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CANzqJaC6U4wc9YimW_B-OGDRQeqgfm8Dem5WYy=a1fAd0mFqSw@mail.gmail.com>
Date: Sat, 29 Jun 2024 16:30:15 -0600
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <6FC0EC91-1B35-415F-9C27-C8B5D85CAA65@elevated-dev.com>
References: 
 <CANzqJaBrzXfebHJaDLRWenr4WRgvRssTgEQR_O20N0sSv9MHLw@mail.gmail.com>
 <792db007dcc03570743afee23aa0da830207f0cf.camel@cybertec.at>
 <CANzqJaAVrQyJ_4ASm0PkmUQ7+U8PHKMTU4NAGFzM0w4FN5tDrQ@mail.gmail.com>
 <42d837098e471906e23ed5ef345a1172145c76da.camel@cybertec.at>
 <CANzqJaBDNN9r=uK3jKtmGCCo2k55fJXK9n6CAhL5WN8pa_0pLQ@mail.gmail.com>
 <2207734.1719672845@sss.pgh.pa.us>
 <CANzqJaC6U4wc9YimW_B-OGDRQeqgfm8Dem5WYy=a1fAd0mFqSw@mail.gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
X-Mailer: Apple Mail (2.3774.600.62)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/6FC0EC91-1B35-415F-9C27-C8B5D85CAA65%40elevated-dev.com>
Precedence: bulk

Could it be that someone accidentally changed ownership after data had =
been created?