Thomas Tignor <tptignor@yahoo.com> wrote on 03/25/2019 08:25:49 PM:
>
> Hi Brad,
> Thanks for writing. As I mentioned to Vijay, the "source" is a JVM
> using the postgres v42.0.0 JDBC driver. I do not believe we have any
> explicit encoding set, and so I expect the client encoding is
> SQL_ASCII. The DB is most definitely UTF8.
These statements are contradictory.
The value of client_encoding from your select on pg_settings is SQL_ASCII.
The docs clearly state:
https://www.postgresql.org/docs/9.5/runtime-config-client.html
"Sets the client-side encoding (character set). The default is to use the database encoding. "
If you don't have client_encoding explicitly, then it is using the database encoding.
Run this on both the primary and replica to confirm the DB's are indeed both in UTF8 encoding:
SELECT datname, pg_encoding_to_char(encoding) FROM pg_database ;
Brad
