MIME-Version: 1.0
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <fd548bde-54d3-426a-a2b6-058750cfb554@aklaver.com> <AS2PR05MB1075432E74AF2FA975B02519AEF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <b1fec029-b8fb-4177-a01a-9457e813ce68@aklaver.com> <AS2PR05MB107546BEE7B8092148A0B51A0EF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <25b5291f-a3d3-4655-a3d3-57f28b70ec5a@aklaver.com> <AS2PR05MB107546C1B04FC4B3CCF32E60CEF7DA@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <78328b08-249e-4251-8a10-b5dac183442a@aklaver.com> <DB5PR05MB107646FFE78759D1D5431F802EF7AA@DB5PR05MB10764.eurprd05.prod.outlook.com>
 <0868c260-9812-4629-b32d-026c1fe6089f@aklaver.com> <AS2PR05MB1075476F648651C8CC02D8048EF79A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <CAKAnmmLsxdt51sp-w0JxMi0haGXHFKD2pXURfOSOa5iVzjni4w@mail.gmail.com>
 <7d455186-0cba-4fd5-9f9e-7051627b3ae3@aklaver.com> <CAKAnmmJzw9TeOd=_VtJ430_AhS+asfRLuOg=mgL0yT_K+7X-yQ@mail.gmail.com>
 <2016a784-0644-4932-a0f1-3613c2521c78@aklaver.com> <CAKAnmmJogm0T4vF5nvhzK=GbfAcPhsLtKR_yRn-neMQP7S2_YQ@mail.gmail.com>
 <AS2PR05MB10754848BE9C45CEF4F881D5AEF46A@AS2PR05MB10754.eurprd05.prod.outlook.com>
In-Reply-To: <AS2PR05MB10754848BE9C45CEF4F881D5AEF46A@AS2PR05MB10754.eurprd05.prod.outlook.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 10 Mar 2026 10:43:45 -0400
Message-ID: <CAKAnmmKwGsCtCeQ2GvDVhp9ZTjSsoZBrfe1Yw_UfcHD1u=StUw@mail.gmail.com>
Subject: Re: Index (primary key) corrupt?
To: Wim Rouquart <wim.rouquart@kbc.be>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000e2349064cac8e8a"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKwGsCtCeQ2GvDVhp9ZTjSsoZBrfe1Yw_UfcHD1u%3DStUw%40mail.gmail.com>
Precedence: bulk

--0000000000000e2349064cac8e8a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Mar 10, 2026 at 10:24=E2=80=AFAM Wim Rouquart <wim.rouquart@kbc.be>=
 wrote:

> Let me get this straight, are you still contesting that the index is
> actually not part of the dumpfile and I somehow just keep on =E2=80=98mis=
sing it=E2=80=99?
>
That is one possibility, yes, but there are others. We just don't have
enough data. It would be great to see exactly what pg_dump is doing so we
know where the corruption/disconnect is. If you have access, could you try:

psql -c "alter system set log_statement=3D'all' " -c "select pg_reload_conf=
()"

pg_dump -t bcf_work_type --schema-only > bcf.debug

psql -c "alter system reset log_statement" -c "select pg_reload_conf()"

Then send us bcf.debug as well as the Postgres logs generated during that
request?


Cheers,
Greg

--0000000000000e2349064cac8e8a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Mar 10, 2026 at 10:24=E2=80=AFAM =
Wim Rouquart &lt;<a href=3D"mailto:wim.rouquart@kbc.be">wim.rouquart@kbc.be=
</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg-765730068680=
2907640">


<div lang=3D"NL-BE" style=3D"overflow-wrap: break-word;">
<p style=3D"font-family:Calibri;font-size:10pt;color:rgb(0,0,0);margin:15pt=
;font-style:normal;font-weight:normal;text-decoration:none" align=3D"Center=
"><span style=3D"font-size:11pt;font-family:Arial,Helvetica,sans-serif;colo=
r:rgb(34,34,34)">Let me get this straight, are you still contesting that th=
e index is actually not part of the dumpfile and I somehow just keep on =E2=
=80=98missing it=E2=80=99?=C2=A0=C2=A0</span></p></div></div></blockquote><=
div>That is one possibility, yes, but there are others. We just don&#39;t h=
ave enough data. It would be great to see exactly what pg_dump is doing so =
we know where the corruption/disconnect is. If you have access, could you t=
ry:</div><div><br></div><div>psql -c &quot;alter system set log_statement=
=3D&#39;all&#39; &quot; -c &quot;select pg_reload_conf()&quot;</div><div><b=
r></div><div>pg_dump -t bcf_work_type --schema-only &gt; bcf.debug</div><di=
v><br></div><div><div>psql -c &quot;alter system reset log_statement&quot; =
-c &quot;select pg_reload_conf()&quot;</div><div><br></div></div><div>Then =
send us bcf.debug as well as the Postgres logs generated during that reques=
t?</div><div><br></div><div>=C2=A0</div></div><div dir=3D"ltr" class=3D"gma=
il_signature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></=
div></div></div></div>

--0000000000000e2349064cac8e8a--