Aug
13
2024
--

Solving pg_upgrade and lc_collate Mismatch Issues in PostgreSQL

pg_upgrade and lc_collate mismatchCharacter collations determine the sort order and classification of characters. When creating a database with initdb, PostgreSQL normally sets the collation based on the operating system’s locale settings, but other special collations, such as “C,” “POSIX,” and “ucs_basic,” are available as alternatives. On Linux systems, updates to glibc can bring changes to collation rules. Normally, […]

Written by in: Insight for DBAs,Lalit PP,pg_upgrade,postgresql,Zend Developer |

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com