Comment by wadefletch
2 hours ago
You can't have any other connections while a Copy-on-Write is happening, not even a logical replication slot. So you keep a read replica that then gets all connections briefly cut for the COW to avoid locking the master instance. Then you re-enable the logical replication slots on both the new, copied instance and the "copyable" read replica to get both back up to date w/ master.
Thanks for sharing your workflow. My question is about why two databases on the same server would need two separate postgres instances.