Replication slot dropped in Bidirection rep: column addition - Mailing list pgsql-admin

From ravi k
Subject Replication slot dropped in Bidirection rep: column addition
Date
Msg-id CAFL4M8EiVH6e8PNTogX5YgMa3U70G-oUn=RkdXZsS6yKp-B-WQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hi Team,

I noticed replication drops while adding column to the table in postgres16.

There is not much delay in adding column to the both servers.

Here are the steps to reproduce:

Server1: 
    --run infinite loop tx with each loop commit and delay for 3 sec
    --another session ran the following column addition 
ALTER TABLE customers  
ADD COLUMN phone VARCHAR(25); 


Server2: 
    --run infinite loop tx with each loop commit and delay for 3 sec
    --another session ran the following column addition 
ALTER TABLE customers  
ADD COLUMN phone VARCHAR(25); 


Please let me know if this is a bug in postgres16 or Am I missing something?

Due to this issue ,I am planning to disable subscriptions while adding new columns ?

Thanks,
Ravi




 

pgsql-admin by date:

Previous
From: Matt Pearson
Date:
Subject: Re: Queries in replica are failing
Next
From: S Hoffman
Date:
Subject: Re: Where to learn PostgreSQL for free?