Re: Convert from LATIN9 to UTF-8 / WAL Replication

Em ter, 9 de mai de 2017 às 17:40, basti <mailinglist(at)unix-solution(dot)de>
escreveu:

> Hello,
>
> I must convert a Latin9 Pg-cluster (Version 9.1) in utf-8 with minimal
> downtime, if possible.
> My idea is to use WAL replication for that.
> Is it usable for that or in other words, can WAL Replication handle
> different encoding on master/slave?

Short answer: no!

Is there perhaps an other way to do that?

I never tried it, but you can use some logical replication tool like Slony.

Is it possible to use on Master Version 9.1 and on Slave 9.6 (it will
> get the new master in the next step)?
>
>
Unfortunately no because on 9.1 version we don't have support for logical
replication yet. We start supporting it since 9.4 using pglogical
extension. As I said before you should consider use one external
replication tool like Slony to do this job.

Regards,

--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento