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

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: [GENERAL] Convert from LATIN9 to UTF-8 / WAL Replication
Дата
Msg-id CAPfkCSB+XHcuw+xzA0TUw7DDJM5J4EOqQ2w0Mdm=2rGjnZvqrg@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Convert from LATIN9 to UTF-8 / WAL Replication  (basti <mailinglist@unix-solution.de>)
Ответы Re: [GENERAL] Convert from LATIN9 to UTF-8 / WAL Replication
Список pgsql-general
Дерево обсуждения

Em ter, 9 de mai de 2017 às 17:40, basti <mailinglist@unix-solution.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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Armand Pirvu (home)"
Дата:
Сообщение: Re: [GENERAL] views and fdw usage and performance
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] views and fdw usage and performance