Convert from LATIN9 to UTF-8 / WAL Replication

From: basti <mailinglist(at)unix-solution(dot)de>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Convert from LATIN9 to UTF-8 / WAL Replication
Date: 2017-05-09 20:38:30
Message-ID: 47b25b3b-7582-1e14-a3e7-3dfcdd758b8e@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
Is there perhaps an other way to do that?
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)?

Best Regards,
Basti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Armand Pirvu (home) 2017-05-09 21:36:59 views and fdw usage and performance
Previous Message Paul Hughes 2017-05-09 20:00:04 Re: Python versus Other Languages using PostgreSQL