search

fastmonkeys / stellar

Fast database snapshot and restore tool for development
MIT License
3.86k stars 119 forks source link

lock table/rows #20

Closed uptownhr closed 9 years ago

uptownhr commented 10 years ago

Can you answer if taking snapshots will lock tables or rows?

Teemu commented 9 years ago

This was on PostreSQL documentation:

It is possible to create additional template databases, and indeed one can copy any database in a cluster by specifying its name as the template for CREATE DATABASE. It is important to understand, however, that this is not (yet) intended as a general-purpose "COPY DATABASE" facility. The principal limitation is that no other sessions can be connected to the source database while it is being copied. CREATE DATABASE will fail if any other connection exists when it starts; during the copy operation, new connections to the source database are prevented.