Re: [GENERAL] Changing collate & ctype for an existing database - Mailing list pgsql-general

From Albe Laurenz
Subject Re: [GENERAL] Changing collate & ctype for an existing database
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53A82BF0@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: [GENERAL] Changing collate & ctype for an existing database  (rihad <rihad@mail.ru>)
List pgsql-general
rihad wrote:
> Btw, can we wrap the update of datcollate &datctype and rebuilding of
> textual indices inside a transaction with effectively 0 downtime?

No.  Building indexes takes time and will lock the tables
until the transaction is done.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Gregory Nicol
Date:
Subject: Re: [GENERAL] LDAP authentication without OU in ldapbasedn
Next
From: marcelo
Date:
Subject: [GENERAL] What is exactly a schema?