public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Wim Rouquart <[email protected]>
To: Greg Sabino Mullane <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Index (primary key) corrupt?
Date: Fri, 13 Feb 2026 09:32:47 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <AS2PR05MB107546BEE7B8092148A0B51A0EF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
	<CAKAnmmLNaQ9NnjP=-kMj4t6wjt3+5nmMbQc2+F2Ekv_=zJWs5w@mail.gmail.com>
	<AS2PR05MB10754BFE319E2594C9E076EE2EFFDA@AS2PR05MB10754.eurprd05.prod.outlook.com>
	<[email protected]>
	<AS2PR05MB107549DDE42DC0B8E31CB52BFEF90A@AS2PR05MB10754.eurprd05.prod.outlook.com>
	<[email protected]>
	<AS2PR05MB10754EE81F34146EE8972713EEF91A@AS2PR05MB10754.eurprd05.prod.outlook.com>
	<[email protected]>
	<AS2PR05MB107541E760AECB8639BB968B5EF63A@AS2PR05MB10754.eurprd05.prod.outlook.com>
	<[email protected]>
	<AS2PR05MB1075432E74AF2FA975B02519AEF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
	<[email protected]>
	<AS2PR05MB107546BEE7B8092148A0B51A0EF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>



On 2/13/26 8:27 AM, Wim Rouquart wrote:
> Internal
> 
> 1) ) It won't be included with the CREATE TABLE statement per:-
> 
> Yes, let's keep it at: it's not in the dumpfile anywhere.
> 
>> 2) The issue seems to be not the dump, but the non-functional state of the index on the source database.
> 
>> Is there any indication of why that is happening?
> 
> Not as far as I know.

So the REINDEX on the source PK is prompted by it not showing up on the 
target?

> 
>> Also what error do you get on the source database that tells you the PK is not working?
> 
> None, only noticed the issue because of the datarefresh to another instance where it turned out the primary key was not created in the target (because it was not in the dumpfile).

On the test instance you set up with pg_basebackup and that has the 
corrupted index what happens if you try to INSERT a record with a 
duplicate id?

> 

>> I hope this clears out any confusion.
>>
>> -----Original Message-----
> Adrian Klaver
> [email protected]
> 
> Disclaimer <https://www.kbc.com/KBCmailDisclaimer;

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Index (primary key) corrupt?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox