Re: PgSQL 14 - Logical Rep - Single table multiple publications?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 02/08/22, Robert Blayzor (rblayzor.bulk@xxxxxxxx) wrote:
> On 8/2/22 10:57, Rory Campbell-Lange wrote:
> > Special care must be taken with the "replica identity" of published
> > tables, as set out at
> > https://www.postgresql.org/docs/current/logical-replication-publication.html.
> 
> We would literally just be merging bulk data rows that are considered
> immutable, meaning they would never be updated or deleted. We would
> replicate only inserts, not deletes, updates, etc.
> 
> Would the table identifier still be required in this case?

On the page referenced above is the following:

"INSERT operations can proceed regardless of any replica identity."

So you should be good.

Rory





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux