Replication slot dropped in Bidirection rep: column addition

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

 



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




 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux