PostgreSQL vector index corruption after standby promotion during failover
Problem After a primary PostgreSQL cluster outage, the standby server was promoted and the database was restored from a recent base backup. Subsequent similarity‑search queries that rely on pgvector indexes start failing with errors such as: ERROR: could not read index file “base/16384/12345”: Invalid argument DETAIL: Index “vector_idx” appears to be corrupted. HINT: Reindex the … Read more