| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, "Guo, Adam" <adamguo(at)amazon(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Jim Mlodgenski <jimmy76(at)gmail(dot)com> |
| Subject: | Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation |
| Date: | 2024-09-10 22:05:45 |
| Message-ID: | 20240910220545.de.nmisch@google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Sep 10, 2024 at 05:56:47PM -0400, Tom Lane wrote:
> Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> writes:
> > On Tue, Sep 10, 2024 at 11:57 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> Yeah, that seems like it could work. But are we sure that replicas
> >> get a copy of the primary's control file rather than creating their
> >> own?
>
> > Yes, I think so. Since at least the system identifiers of primary and
> > replicas must be identical for physical replication, if replicas use
> > their own control files then they cannot start the replication.
>
> Got it. So now I'm wondering if we need all the complexity of storing
> stuff in the GIN metapages. Could we simply read the (primary's)
> signedness out of pg_control and use that?
Yes.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2024-09-10 22:23:09 | Re: Retire support for OpenSSL 1.1.1 due to raised API requirements |
| Previous Message | Tom Lane | 2024-09-10 21:56:47 | Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation |