3 ms·
I wanted to try doing something similar to this in our dev environment (think shared dev database but per branch clones), but this limitation seemed tricky to a
by mnahkies 5mo ago
I wanted to try doing something similar to this in our dev environment (think shared dev database but per branch clones), but this limitation seemed tricky to accept:
> The source database can't have any active connections during cloning.
I wouldn't mind some lock contention, but having to kill all connections seemed a bit harsh
- IdontKnowRust 5mo agoI guess it's still possible with a replica that no one is using? So you don't need to touch real production db? Not sure if it applies for all use cases tou
- mnahkies 5mo agoYeah I think a read replica might fit the bill - though I suspect active logical replication counts as a connection in this context. Using a cloud provider read replica might not (as I think that might use block level replication) - but then you're paying for an extra dev database host for the privilege