Re: Index (primary key) corrupt? - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Index (primary key) corrupt?
Date
Msg-id CAKAnmmKwGsCtCeQ2GvDVhp9ZTjSsoZBrfe1Yw_UfcHD1u=StUw@mail.gmail.com
Whole thread
In response to RE: Index (primary key) corrupt?  (Wim Rouquart <wim.rouquart@kbc.be>)
Responses Re: Index (primary key) corrupt?
List pgsql-general
On Tue, Mar 10, 2026 at 10:24 AM 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 ‘missing it’?  

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='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

pgsql-general by date:

Previous
From: Wim Rouquart
Date:
Subject: RE: Index (primary key) corrupt?
Next
From: Adrian Klaver
Date:
Subject: Re: Index (primary key) corrupt?