The UNIX system Glibc library version 2.28 requires you to re-index all PostgreSQL databases


The Glibc library version 2.28 has been released on a majority of Linux systems. This new version introduced changes that affect the sort order of database queries. 

If your system contains Glibc 2.28, you must issue the REINDEX command on every PostgreSQL database residing on the updated host server. This procedure must be applied to the following:

To learn more about the reindex of PostgreSQL databases and see examples, reference the following pages:

For more information about the Glibc library, see The GNU C Library (glibc).

For more information about this specific issue, see the "Beware of your next glibc upgrade" article.