New answers tagged

1 vote

logical replication initial phase

re 1) No, you don't need to do anything. As soon as you create the subscription, Postgres will copy the data. You can prevent the initial copy if you wanted to, by using with (copy_data = false) when ...
user avatar
0 votes

I am looking for a query to determine when the snapshot has been finished applying on the subscriber

select * from MSdistribution_history where comments like 'delivered snapshot%'
user avatar
  • 11
0 votes

SQL server replication conflicts

This is likely because the Articles that are used in both your Snapshot and Transactional Publications have their Destination Object properties set to "Truncate all data in the existing object&...
user avatar
  • 25.6k

Top 50 recent answers are included