Thread: BSD initdb without ICU support and switch later
Hello, the ICU patch isn’t ready for PostgreSQL on FreeBSD. Is there any risk (more than 0) in executing the initdb without ICU support and recompiling PostgreSQL later when the ICU patch is ready? I mean any risk without making a dump and import before the switch. If this is okay for sure, what should I do later when the ICU is available? Do I have to reindex everything with the ICU patched database? Thank you. M.
On 29/01/2016 16:46, Maeldron T. wrote: > Hello, > > the ICU patch isn’t ready for PostgreSQL on FreeBSD. https://people.freebsd.org/~girgen/postgresql-icu/readme.html > > Is there any risk (more than 0) in executing the initdb without ICU > support and recompiling PostgreSQL later when the ICU patch is ready? I > mean any risk without making a dump and import before the switch. > > If this is okay for sure, what should I do later when the ICU is > available? Do I have to reindex everything with the ICU patched database? > > Thank you. > > M. > > > -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
On Fri, Jan 29, 2016 at 5:46 PM, Maeldron T. <maeldron@gmail.com> wrote:
Hello,
the ICU patch isn’t ready for PostgreSQL on FreeBSD.
Is there any risk (more than 0) in executing the initdb without ICU
support and recompiling PostgreSQL later when the ICU patch is ready? I
mean any risk without making a dump and import before the switch.
Teodor has made a patch for ICU and PostgreSQL 9.5.
If this is okay for sure, what should I do later when the ICU is
available? Do I have to reindex everything with the ICU patched database?
I think, yes.
Thank you.
M.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Jan 30, 2016 at 4:39 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote: > On 29/01/2016 16:46, Maeldron T. wrote: >> >> Hello, >> >> the ICU patch isn’t ready for PostgreSQL on FreeBSD. > > > https://people.freebsd.org/~girgen/postgresql-icu/readme.html If the goal is to get Unicode collation support, note also that FreeBSD 11 (due some time this year) supports that in libc. -- Thomas Munro http://www.enterprisedb.com
Hi there. Just wondering if anyone has got ICU support/patch applied to 9.5 yet. We are holding on 9.4 for now but want to get onto 9.5 asap but can't due to the ICU limitation. Any help appreciated. Thanks. -- View this message in context: http://postgresql.nabble.com/BSD-initdb-without-ICU-support-and-switch-later-tp5884872p5896856.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.