Re: logical decoding and replication of sequences - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: logical decoding and replication of sequences
Date
Msg-id 4e158021-248d-43ad-95e5-943334bd1007@www.fastmail.com
Whole thread Raw
In response to Re: logical decoding and replication of sequences  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: logical decoding and replication of sequences  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers
On Wed, Feb 23, 2022, at 1:07 PM, Tomas Vondra wrote:
Maybe, but I don't think it's very common to have that many schemas
added to the same publication. And it probably does not make much
difference whether you have 1000 or 2000 items in the list - either both
are acceptable or unacceptable, I think.
Wouldn't it confuse users? Hey, duplicate publication. How? Wait. Doh.

I think just hard-coding this into CreatePublicationStmt would work, but
it'll be an issue once/if we start adding more options. I'm not sure if
it makes sense to replicate other relkinds, but maybe DDL?
Materialized view? As you mentioned DDL, maybe we can use the CREATE
PUBLICATION syntax to select which DDL commands we want to replicate.


--
Euler Taveira

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: PATCH: add "--config-file=" option to pg_rewind
Next
From: Nathan Bossart
Date:
Subject: Re: Allow file inclusion in pg_hba and pg_ident files