BSD initdb without ICU support and switch later

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general