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

From: Japin Li <japinli(at)hotmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Sadhuprasad Patro <b(dot)sadhu(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, PostgreSQL Hackers <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-27 01:40:09
Message-ID: MEYP282MB1669159DD5D0B3B745B690A7B6859@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Sat, 23 Oct 2021 at 02:00, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Japin Li <japinli(at)hotmail(dot)com> writes:
>> On Sat, 23 Oct 2021 at 00:55, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> What if the subscriber and publisher are of different PG versions
>>> and have different ideas of the valid values of these settings?
>
>> Sorry, I'm a bit confused. Do you mean we should provide a choose for user
>> to set thoses parameters when establish logical replication?
>
> No, I'm just pointing out that pushing the subscriber's settings
> to the publisher wouldn't be guaranteed to work. As long as we
> use curated values that we know do what we want on all versions,
> I think we're okay.
>

Thanks for your clarification.

--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2021-10-27 01:55:31 Re: Setting log_connection in connection string doesn't work
Previous Message Tom Lane 2021-10-27 01:39:54 Re: [PATCH v2] src/port/snprintf.c: Optimize the common base=10 case in fmtint