Re: Query returns no rows in pg_basebackup cluster
От | Andrus |
---|---|
Тема | Re: Query returns no rows in pg_basebackup cluster |
Дата | |
Msg-id | F43B6DD2AB7F44D7BDC16F51CF8D88F4@dell2 обсуждение исходный текст |
Ответ на | Re: Query returns no rows in pg_basebackup cluster (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Hi! >>> No. Physical copies need to be based on the same platform. >> Does the O/S that the client software runs on really affect this? >To the extent that the O/S determines text sort order, yes; see thread. >The short answer here is that we aren't going to support such cases. >If you try to replicate across platforms, and it works, you're in luck. >If it doesn't work, you get to keep both pieces; we will not accept >that as a bug. In 2017 Peter wrote that ICU-based collations will offered alongside the libc-based collations (1) Currently it still requires re-compilation of Postgres for all binary replication platforms. Maybe ICU locale will selected during installation automatically in Postgres 13 . Using same ICU locale in all replicationplatforms will hopefully fix the issue. Currently option is to use ucs_basic as default collation when creating cluster. (1) https://www.2ndquadrant.com/en/blog/icu-support-postgresql-10/ Andrus.
В списке pgsql-general по дате отправления: