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-bugs-owner+archive@lists.postgresql.org>)
	id 1smeJX-007Nh3-Uu
	for pgsql-bugs@arkaria.postgresql.org; Fri, 06 Sep 2024 19:08:12 +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-bugs-owner+archive@lists.postgresql.org>)
	id 1smeJW-002B7y-AZ
	for pgsql-bugs@arkaria.postgresql.org; Fri, 06 Sep 2024 19:08:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1smeJW-002B7q-0R
	for pgsql-bugs@lists.postgresql.org; Fri, 06 Sep 2024 19:08:10 +0000
Received: from smtp90.iad3a.emailsrvr.com ([173.203.187.90])
	by makus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1smeJU-000U71-1z
	for pgsql-bugs@lists.postgresql.org; Fri, 06 Sep 2024 19:08:09 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp28.relay.iad3a.emailsrvr.com (Authenticated sender:
 xof-AT-thebuild.com) with ESMTPSA id 8F8BC52D9;
	Fri,  6 Sep 2024 15:08:06 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: BUG #18604: Regression in PostgreSQL 16.4: pg_dump Prevents
 Essential System Table Modifications
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <18604-04d64b68e981ced6@postgresql.org>
Date: Fri, 6 Sep 2024 12:07:35 -0700
Cc: PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <5129DA7F-C4DF-4B87-A64B-C705DDB2C502@thebuild.com>
References: <18604-04d64b68e981ced6@postgresql.org>
To: basha@maxcontact.com
X-Mailer: Apple Mail (2.3774.600.62)
X-Classification-ID: 55dae9f6-b9e8-42df-bd4d-3ad1bec5bc09-1-1
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/5129DA7F-C4DF-4B87-A64B-C705DDB2C502%40thebuild.com>
Precedence: bulk



> On Sep 6, 2024, at 09:28, PG Bug reporting form =
<noreply@postgresql.org> wrote:
> However, after the PostgreSQL 16.4 update, pg_dump now fails due to =
these
> system table modifications, leaving us in a precarious position where
> essential backups cannot be performed.

It should be noted that this change does not prevent PITR backups, so it =
is still entirely possible to back up your installation.=