Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ni0jk-0005y6-DE
	for pgsql-admin@arkaria.postgresql.org; Fri, 22 Apr 2022 21:22:44 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ni0jj-00033v-5X
	for pgsql-admin@arkaria.postgresql.org; Fri, 22 Apr 2022 21:22:43 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1ni0ji-00033f-MR
	for pgsql-admin@lists.postgresql.org; Fri, 22 Apr 2022 21:22:42 +0000
Received: from mail-wr1-x429.google.com ([2a00:1450:4864:20::429])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1ni0jf-0001g9-CL
	for pgsql-admin@lists.postgresql.org; Fri, 22 Apr 2022 21:22:41 +0000
Received: by mail-wr1-x429.google.com with SMTP id m14so12745711wrb.6
        for <pgsql-admin@lists.postgresql.org>;
 Fri, 22 Apr 2022 14:22:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec-at.20210112.gappssmtp.com; s=20210112;
        h=message-id:subject:from:to:date:in-reply-to:references:user-agent
         :mime-version:content-transfer-encoding;
        bh=JgXQ4GXfcV6IEEoc2YUARElfzh0J28VS8VWf542wlfE=;
        b=SEsBIaZ5nTW5ldwM1BR1wlYJU3tBMmTqEBCuJDAAE0xMhBM53RDBIbUE7vOrwmMYcR
         z3sdcAROM66ZI7f0xWX8d84IVVNDJn4iEP2uUEgDmel8zXGCDB1sR+w5z15tY8g8OT/o
         7y7i4g4ZZFBkkDWH86wy/nTVUYIBOueQ2ZB3WXw4/srH0vN9dCcxJeuAvei2qyrs01k3
         Rivi1XC/oGzvCdZkhkrjAGqw6qrf4pa6sng/ntWP6UHj8St/JRQPKgazpqMR2DzXsJLG
         FlDckFke9K32N4T67E3OT7shfm3kSeUch6t2SecpZk7qCU0xh04PysGtRNaX0r3MgflC
         Lrnw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to
         :references:user-agent:mime-version:content-transfer-encoding;
        bh=JgXQ4GXfcV6IEEoc2YUARElfzh0J28VS8VWf542wlfE=;
        b=QHfivyQlvUoP8WRRvbk7hHnSoI79DevR9E7oHRKIRfE5/25AY6OGAt+8CoVruQTjPZ
         M7i5NipQnI95yZml49Pwyq3PYK+MB9zvSjGmPkTMVQ2q3rHuEsfJyY0TB8Klo/gfcecC
         izYfzTByiHC79+ONlJpzIWNpqeIKl0yPOVp10ZJvaBsmH5Hp4NiQcmKW/dRI/OYl+EZa
         t93PoXlh1L7rsncLsLp8uwUvq4oOG4OEQaz0PDrfwLaDynuNj+n9h1FWyKluflRpZrgG
         2xU1BFaRWQpWek2cUtBYZgQgtQznnHmfZjapdOH6RntWLcBKHmXVk2OBFuDdBUMoBxM6
         FjIA==
X-Gm-Message-State: AOAM533Ru9k164RGyyqL8ueNgwP2XEzaUL1nbrLScDMwEmOmq1mvaERX
	lxc/Mv+t7tvy1pIAKR8gkVl5VIwWo2UFRQ==
X-Google-Smtp-Source: 
 ABdhPJzYZcYPDHW2iNChsoPxLlCI7XOvQGdIkUwhKgDruvolJ6KexT2SplJDsRLE0LWf1AaZVNqGXg==
X-Received: by 2002:adf:fc85:0:b0:20a:cb61:5855 with SMTP id
 g5-20020adffc85000000b0020acb615855mr3472008wrr.459.1650662556897;
        Fri, 22 Apr 2022 14:22:36 -0700 (PDT)
Received: from localhost.localdomain (178-190-170-214.adsl.highway.telekom.at.
 [178.190.170.214])
        by smtp.gmail.com with ESMTPSA id
 z3-20020a1cf403000000b0037d1f4a2201sm2489303wma.21.2022.04.22.14.22.36
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 22 Apr 2022 14:22:36 -0700 (PDT)
Message-ID: <fb7da4bd1fe790ffee49a3ffd0f004ff421276ed.camel@cybertec.at>
Subject: Re: could not read block 0 in file Error
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sbob <sbob@quadratum-braccas.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Fri, 22 Apr 2022 23:22:35 +0200
In-Reply-To: <938c7425-076f-f752-de61-c5f8f183d24b@quadratum-braccas.com>
References: <938c7425-076f-f752-de61-c5f8f183d24b@quadratum-braccas.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-5.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
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/fb7da4bd1fe790ffee49a3ffd0f004ff421276ed.camel%40cybertec.at>
Precedence: bulk

On Fri, 2022-04-22 at 14:23 -0600, Sbob wrote:
> pg_dump: error: Dumping the contents of table "bigtable" failed: PQgetResult() failed. 
> pg_dump: error: Error message from server: ERROR:  could not read block 0 in file "base/6328739/6340053": read only 0 of 8192 bytes 
> pg_dump: error: The command was: COPY public.bigtable (recordid, containerid, record_type, description, overlaygroup) TO stdout;
> 
> Is there any way to recover?

No.  The file is obviously empty, so the data in that table are lost.

Your only hope is a good backup.

Yours,
Laurenz Albe