Oleg Bartunov <[EMAIL PROTECTED]> writes: > I'm investigating a problem my client experienced with > "create database xxx with template=yyy" - they often get error > "ERROR: source database "yyy" is being accessed by other users",
Your test case simply shows that it takes a finite amount of time for the previous backend to exit; depending on scheduler priorities it's possible for the next instance to connect and try to CREATE DATABASE before the previous one is gone. My suggestion would be to connect to some other database besides the one being copied. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq