From: | Erik Rijkers <er(at)xs4all(dot)nl> |
---|---|
To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, David Rowley <dgrowleyml(at)gmail(dot)com> |
Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, chelseadole(at)gmail(dot)com |
Subject: | Re: PostgreSQL 16 release announcement draft |
Date: | 2023-08-26 04:28:35 |
Message-ID: | 721d86b6-1111-e152-d84d-176a80430acd@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Op 8/26/23 om 04:51 schreef Jonathan S. Katz:
> On 8/24/23 11:17 AM, Erik Rijkers wrote:
>> Op 8/24/23 om 16:32 schreef Jonathan S. Katz:
>>> On 8/23/23 5:07 PM, David Rowley wrote:
>>>> On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz
>>>> <jkatz(at)postgresql(dot)org> wrote:
>>
>> Hi,
>>
>> When v15 docs have:
>>
>> "27.2.7. Cascading Replication
>> The cascading replication feature allows a standby server to accept
>> replication connections and stream WAL records to other standbys,
>> acting as a relay. This can be used to reduce the number of direct
>> connections to the primary and also to minimize inter-site bandwidth
>> overheads."
>>
>> why then, in the release draft, is that capability mentioned as
>> something that is new for v16?
>> "
>> In PostgreSQL 16, users can perform logical decoding from a standby
>> instance, meaning a standby can publish logical changes to other servers.
>> "
>>
>> Is there a difference between the two?
>
> Yes. Those docs refer to **physical** replication, where a standby can
> continue to replicate WAL records to other standbys. In v16, standbys
> can now publish changes over **logical** replication.
Well, I must assume you are right.
But why is the attached program, running 3 cascading v15 servers,
showing 'logical' in the middle server's (port 6526)
pg_replication_slots.slot_type ? Surely that is not physical but
logical replication?
port | svn | slot_name | slot_type
------+--------+--------------------+-----------
6526 | 150003 | pub_6527_from_6526 | logical <--
(1 row)
I must be confused -- I will be thankful for enlightenment.
Erik
> Thanks,
>
> Jonathan
>
Attachment | Content-Type | Size |
---|---|---|
logrep_cascade_15.sh | application/x-shellscript | 6.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2023-08-26 11:17:19 | Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue |
Previous Message | Hayato Kuroda (Fujitsu) | 2023-08-26 04:25:34 | RE: [PoC] pg_upgrade: allow to upgrade publisher node |