From: | Japin Li <japinli(at)hotmail(dot)com> |
---|---|
To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
Cc: | Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: [Bug] Logical Replication failing if the DateStyle is different in Publisher & Subscriber |
Date: | 2021-10-16 14:42:02 |
Message-ID: | MEYP282MB1669F91DF08E358E0E8AB8A4B6BA9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, 14 Oct 2021 at 19:49, Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
> On Thu, Oct 14, 2021 at 3:48 PM Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com> wrote:
>>
>> Hi All,
>>
>> Publisher 'DateStyle' is set as "SQL, MDY", whereas in Subscriber as
>> "SQL, DMY", the logical replication is not working...
>>
>> From Publisher:
>> postgres=# INSERT INTO calendar VALUES ('07-18-1036', '1'), ('05-15-1135', '1');
>> INSERT 0 2
>>
>> Getting below error in the subscriber log file,
>> 2021-10-14 00:59:23.067 PDT [38262] ERROR: date/time field value out
>> of range: "07/18/1036"
>> 2021-10-14 00:59:23.067 PDT [38262] HINT: Perhaps you need a
>> different "datestyle" setting.
>>
>> Is this an expected behavior?
>
> Looks like a problem to me, I think for fixing this, on logical
> replication connection always set subscriber's DateStlyle, with that
> the walsender will always send the data in the same DateStyle that
> worker understands and then we are good.
Right! Attached fix it.
--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.
Attachment | Content-Type | Size |
---|---|---|
fix-logical-replication-failing-when-in-different-datestyle.patch | text/x-patch | 1.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Zhihong Yu | 2021-10-16 15:31:36 | Re: Reset snapshot export state on the transaction abort |
Previous Message | Bruce Momjian | 2021-10-16 14:16:25 | Re: XTS cipher mode for cluster file encryption |