Re: postgres 9.5 DB corruption: invalid byte sequence for encoding "UTF8"

2019-03-26 Thread Thomas Tignor
Hi Laurenz. Thanks for writing. I can tell you that while the error message usually identifies just one byte (though sometimes up to three), inspection of the data has frequently shown several bytes impacted. It often seems that the corruption begins at one point in the row and continues to the

Re: postgres 9.5 DB corruption: invalid byte sequence for encoding "UTF8"

2019-03-26 Thread Laurenz Albe
Thomas Tignor wrote: > We are experiencing intermittent DB corruption in postgres 9.5.14. We are > trying to > identify and eliminate all sources. We are using two independent services for > data > replication, Slony-I v2.2.6 and a custom service developed in-house. Both are > based > on COPY op