Re: BUG #17245: Index corruption involving deduplicated entries

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: "K(dot) R(dot)" <iijima(dot)yun(at)koumakan(dot)jp>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
Date: 2021-10-25 22:05:07
Message-ID: CA+hUKGKzpseC3j3c8P6gKJ0+5e8fHOCw3FOrPY+4TmKoJpGQBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Oct 26, 2021 at 10:08 AM K. R. <iijima(dot)yun(at)koumakan(dot)jp> wrote:
> [...] I do not use pg_upgrade since
> different versions of PostgreSQL cannot be installed at the same time in
> FreeBSD using the ports/packages system, and I do not find dump/restore
> much a chore (plus it solves issues with possible locale changes).

It really would be nice to address that. (FWIW A few years ago I had a
mostly-working experiment-grade patch for the ports tree that could
install and run multiple versions in parallel, and the bones of a port
of the Debian wrapper scripts and cluster control tools so you can
list, start, stop, clone clusters etc, but I ran out of steam while
contemplating the squillions of other packages that interact with
PostgreSQL... happy to share the starter bits and pieces I have
off-list if anyone is interested...). But in this particular case it
significantly reduces the search area for the problem, so that's a
useful deficiency!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2021-10-25 23:18:52 Re: BUG #17245: Index corruption involving deduplicated entries
Previous Message Peter Geoghegan 2021-10-25 21:29:33 Re: BUG #17245: Index corruption involving deduplicated entries