Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber

On Mon, Oct 18, 2021 at 1:41 PM Japin Li <japinli@hotmail.com> wrote:

> I attached v3 patch that set IntervalStyle to 'postgres' when the
> server backend is walsender, and this problem has gone.

> I test that set IntervalStyle to 'sql_standard' on publisher and
> 'iso_8601' on subscriber, it works fine.

> Please try v3 patch and let me know if they work as unexpected.
> Thanks in advance.

I think the idea of setting the standard DateStyle and the
IntervalStyle on the walsender process looks fine to me.  As this will
avoid extra network round trips as Tom mentioned.

-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com