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 1sgWvY-003a4T-H9 for pgsql-es-ayuda@arkaria.postgresql.org; Tue, 20 Aug 2024 22:02:08 +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 1sgWvW-0040AE-DI for pgsql-es-ayuda@arkaria.postgresql.org; Tue, 20 Aug 2024 22:02:06 +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 ) id 1sgWvW-0040A6-3k for pgsql-es-ayuda@lists.postgresql.org; Tue, 20 Aug 2024 22:02:06 +0000 Received: from fhigh5-smtp.messagingengine.com ([103.168.172.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgWvS-000fzF-KK for pgsql-es-ayuda@postgresql.org; Tue, 20 Aug 2024 22:02:06 +0000 Received: from phl-compute-01.internal (phl-compute-01.nyi.internal [10.202.2.41]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 4E9D4114EE68; Tue, 20 Aug 2024 18:02:02 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Tue, 20 Aug 2024 18:02:02 -0400 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=1724191322; x= 1724277722; bh=XiV9oiP9q4jR49L70l8AExORAMfB+92NJ9AqltyG3Ns=; b=S MpEYNeUt+/m+enwmx0QW4TEKcUuDk0Q268tEJmtAfd49jVWoa4VcdWhsMhOMWUHY vT1f8y8eCdr9vOqP4aCTKKJUnn4pqbqIES2OOuOqYDsFwk6rah3Cm8WYETo3nvLI lGe81T/lZvSeqVG31pU6IVbvEWHeawtlbscRLugVf10ABEBbax8tPcnqTUm7wgTe EDFCUnu5KjACJ6IzWcDEDXC2nf9W3ZIzAG6WQRojnSHU3uTNJvDBRFEcfaskpRld qXzz1vhW8VU0GjmhPMArP0OceSLlowtxGnzBQwUSTxMDBHO85G/EaJ4kN40ddVja lKkmPm2m1odMzBUd6yM0A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddruddujedgtdehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeen ucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhh drnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffh jeejhffgieeuueekjeekfffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrph hrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgpdhnsggprh gtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehfhhhurhhtrggu ohesghhruhhpohgrshgurdgtohhmpdhrtghpthhtohepphhgshhqlhdqvghsqdgrhihuug grsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 20 Aug 2024 18:02:00 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1724191317; bh=pzKGfApAigI1JujGrCD2/ANIC7YLJALlI5vd7204Wvo=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=CVw1g3OZBn4rtQtb4WQzfZ/pfYFZSFWoiF0zk1ERixVq+Yp3Dsk4BXWVr/2VJjMb9 Hl2i8wCr1zotpdFuUI8BR8w4ECZXWvPUovR0hVNNZ4p5PrQ82ARsqIGqNvKabfVZnb rVXva1CGdX77X+iEasbdUlbVN17oPS7g4rL3u58yMjk4uKdEF/KZ7qaHNcbAmHGNGa GuhxxPIAKTubqg/JQweoS0jAgReBofyNHUMM/V+1s+uYDtgLfA8lbwrHoJ2fD5QJZ/ yOvdKCpT4As9s4qpLzUng0JLSEcve/uzeg4ZixdGQgj+3cKQOuSce6SJbB05JnGvi1 5a1l9LCFg4S7g== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id CF7E8E9; Tue, 20 Aug 2024 18:01:57 -0400 (-04) Date: Tue, 20 Aug 2024 18:01:57 -0400 From: Alvaro Herrera To: Fredy Hurtado Cc: pgsql-es-ayuda@postgresql.org Subject: Re: Backup postgres Message-ID: <202408202201.gadb7d4m7ta3@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Fredy Hurtado escribió: > Buenas tardes, > > Estoy generando un backup en Postgres 15.7 sobre Debian 12 y al momento de > lanzarlo, me aparece este error: > > pg_dump: error: la consulta falló: ERROR:  no se pudo leer el bloque 0 del > archivo «base/36094/3119»: Error de entrada/salida Ese error viene del sistema operativo, y muy probablemente indica que uno de tus discos está muriendo. 3119 es un índice en el catálogo de sistema pg_foreign_table. Quizás puedas recuperar esto haciendo REINDEX TABLE pg_foreign_table en la base de datos afectada, aunque nunca se puede saber si no tienes corrupción en alguna otra parte, especialmente en archivos con datos de tabla. Recomendaría que saques tus datos de esa máquina, o de ese disco, para restaurarlos en una máquina confiable, antes de seguir operando. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "La vida es para el que se aventura"