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 ) id 1rf23N-00F1GV-4D for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Feb 2024 18:19:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rf23L-004sfw-Mr for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Feb 2024 18:19:44 +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 ) id 1rf23L-004sfo-50 for pgsql-bugs@lists.postgresql.org; Tue, 27 Feb 2024 18:19:43 +0000 Received: from fout5-smtp.messagingengine.com ([103.168.172.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rf23H-001Z5n-SQ for pgsql-bugs@lists.postgresql.org; Tue, 27 Feb 2024 18:19:42 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailfout.nyi.internal (Postfix) with ESMTP id 4B20113800FE; Tue, 27 Feb 2024 13:19:40 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Tue, 27 Feb 2024 13:19:40 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1709057980; x= 1709144380; bh=ybvNsUt/ggQeUemGDiByHkSDkCdide6jJmt5n1QZjs8=; b=G gfg59fAYY3007sIRl0AHbJHjnHozozEwZkZA8oiGYBJxrvsq6wadiwhhPhdls+7E cbkoL13ys6Flf7ykBQUR0qWsMbtzdUqh9v67met8zRp2pJdhmrXa6BCVM2cTrtNb 0X/ebm5271N7+4sYFiqSMwGdivAS/WmNWbllF9LV446myQoLz+2ji0dfarRCj7oX YH66PIVbpnKnNYBIHtrVV2tX2acqVToGi0jJhYF2Z1FVPEqIwGrYMwBG6c8LIjLW ImnHerOUChB+l5LUwIzlDJOozfLES9c/DFSo0PjmeTjX3GNPWwMu90V/S1oEQPSV E6S7OKn1c/qMxkRQjvWJg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrgeehgdekiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkgggtugfgjgesthekre dttddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgv segrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepvdektdffudfftd ffffehfffhjeejhffgieeuueekjeekfffgudffhfduffffueevnecuffhomhgrihhnpegv nhhtvghrphhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 27 Feb 2024 13:19:39 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1709057976; bh=uWgQvvikT3YpATg8CpwQvsiXyetOqIY4CO0uwK2+4qg=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=bUsKTMedINOpeAEuMBw/0TsoDmPRLKm42n1e3+sgST0bq/sVCpLizRmrebFsAtvJN 9t18338OpieX4TThxeq23lYO3tDaUhCirxKDxBVwT9qKOXbd6Ww5KJyhUfn95heBpR O3AAU96BVXdgOUgIgjPCXHrhyRjKcxcXr5gstwAtGjTUr210rR+PVy5KzF4aU2sKsT wHGTQUYqpeggB9H8HZ33vgaFF/P7W5Rj6QHn9E/ui+phl+HNFDV3+zOAJgnpF89lyy yKiVBPZXGfX4m8nW5ozb/dXxyFQ2GHKwKKeTnRagehJ8iXUNlCIalr29VgKW84dww0 QcU1Spd3yRvxw== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 87D0712B0; Tue, 27 Feb 2024 19:19:36 +0100 (CET) Date: Tue, 27 Feb 2024 19:19:36 +0100 From: Alvaro Herrera To: Tom Lane Cc: charles@twenty.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18367: Cannot drop schema Message-ID: <202402271819.uxvcer73hf2f@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <2135024.1709057683@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-Feb-27, Tom Lane wrote: > I would try to pg_dump the database, and if you can do that and > reload successfully then discard the original. If you've found > one bit of catalog corruption there's likely more. I second that recommendation. However, there's also pg_catcheck which could help diagnose and fix things, in case a dump/restore of the whole database is impractical. If you operate it wrong enough, you can corrupt your whole database though. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ Voy a acabar con todos los humanos / con los humanos yo acabaré voy a acabar con todos (bis) / con todos los humanos acabaré ¡acabaré! (Bender)