Re: Locking a Database (not tables) x

2014-03-22 Thread Karr Abgarian
Perhaps enabling read only, followed by import with super user will do what you want. On Mar 22, 2014, at 12:26 AM, Manuel Arostegui wrote: > 2014-03-21 18:42 GMT+01:00 David Lerer : > >> Frequently, we import a production dump that contains only 1 or 2 >> databases into one of our QA inst

Re: Locking a Database (not tables) x

2014-03-22 Thread Manuel Arostegui
2014-03-21 18:42 GMT+01:00 David Lerer : > Frequently, we import a production dump that contains only 1 or 2 > databases into one of our QA instances that contains many more databases. > (i.e. "database" being a "schema" or a "catalogue). > At the beginning of the import script, we first drop all