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 ) id 1pywgz-00034Q-Cy for pgsql-admin@arkaria.postgresql.org; Tue, 16 May 2023 15:34:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pywgy-0002HJ-CT for pgsql-admin@arkaria.postgresql.org; Tue, 16 May 2023 15:34:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pywgy-0002H9-1r for pgsql-admin@lists.postgresql.org; Tue, 16 May 2023 15:34:24 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pywgu-000AFT-VU for pgsql-admin@lists.postgresql.org; Tue, 16 May 2023 15:34:23 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-969f90d71d4so1470715166b.3 for ; Tue, 16 May 2023 08:34:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1684251261; x=1686843261; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=fccyiz5uVDHag7eFTxhxnB1r6n175nPYyFgT6SfqBbw=; b=aXDzUN7fhMn5ha42d8694kOYEU5vPqmBlOwI+4AjRtp+e2KYDGRQ2zFXJMU15E0GXW T/Y21Jg7CnVnCTobfrWdvbSe2Zffnu6+YALo7h/P/xqpbLgFx1EPP6QM4Ts3mbh+pBW+ l/3HJpiUhAdtpquca7Q6MXtuQ6YUCsJXkqFg8btiVFm8LW3WPN+wkkDKHJYQJ/bBvTZB w7QAcS1mEDWhWXFux1mf/eQVE2ky9OxzpRTcuvv1Pw13UT6rshysbfMj1CvMp6ptONWy mc5pX96CXV2tnMXykaZOwRqppvbEumqNaN4S3SxHXlh+fPTns6MIn/OHqMN6PTEUfCeN z4EQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684251261; x=1686843261; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=fccyiz5uVDHag7eFTxhxnB1r6n175nPYyFgT6SfqBbw=; b=TwEDbHyLy3cq1pGBB9oM3LIm+E8+Pnp9JCRuYjQggqTVAKbW2isFrWzJZ3RVIFSOdd VduF+lPhIjgMcFkFuiTrKg/Xzz4C7H3Hqkyi9lnxZLfc6be4iHvSXmEhs9KCdOAVhqQK RUaT9M/PPycvsPDAFMKYALFQcnRfoStpvc/Sba+8T1+/xVI8H9z8d/EuH38UscXbQIvO pl+4ppX4AHrP6dOk3nhHGIUrpHD0QjRR2/fA66XSrxNf+97MeGgB7zaFUmFfYWjgm5QF Jt+Vvu1hPVVV9z/qgwVFeIqFGcGeFmgwOV795w839lmcvgTSdpQN4t2JSNaDmdgdzUQv GkOg== X-Gm-Message-State: AC+VfDyseG/fcpT3EpRuyf+Spw9WmHrdqlOwJPJkcfevoS7FUp1pP+lP 1smM4TeZlyzqixKTuhfp0MiQ9+f7mhOMDMJNYasgqw== X-Google-Smtp-Source: ACHHUZ6k//EKK0hA1M9FTzG2asr4F6eNOneDOPWvvONcgPtowy3sZQW225Am3fHrEwNCjxEkJlP0ZQ== X-Received: by 2002:a17:906:ef09:b0:95e:d3f5:3d47 with SMTP id f9-20020a170906ef0900b0095ed3f53d47mr32857283ejs.48.1684251260827; Tue, 16 May 2023 08:34:20 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:8128:c715:40ae:4e8c:8a84]) by smtp.gmail.com with ESMTPSA id ia2-20020a170907a06200b00959c07bdbc8sm11107679ejc.100.2023.05.16.08.34.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 16 May 2023 08:34:20 -0700 (PDT) Message-ID: Subject: Re: Getting error during execution of pg_dump From: Laurenz Albe To: OS DB2 , Pgsql-admin Date: Tue, 16 May 2023 17:34:19 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2023-05-16 at 14:27 +0530, OS DB2 wrote: > In one of the production server we are getting below error when we are tr= ying to take pg_dump of one of the table. >=20 > Error: missing chunk number 0 for toast value 1115988058 in pg_toast_1104= 679371 >=20 > Request you to share your valuable suggestion to resolve the same. You have data corruption. Restore your last good backup. Yours, Laurenz Albe