Am 05.03.19 um 19:09 schrieb Matthew Pounsett:
On Tue, 5 Mar 2019 at 12:54, Tom Lane <tgl@xxxxxxxxxxxxx <mailto:tgl@xxxxxxxxxxxxx>> wrote:Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx <mailto:andreas@xxxxxxxxxxxxxxx>> writes: > the other thing is, it would be nice to to know why the index is corrupt. Given that (a) this was triggered by a server migration and (b) the leading column of the index looks like it's probably varchar, I'm suspicious that the new server has different collation behavior.The migration in question was an rsync from a Debian 9 box running 9.4.19-0+deb8u1 to a FreeBSD 11 box running 9.4.20.
yeah, check and compare the glibc - version on both systems. (ldd --version) Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
