Oleg Bartunov <oleg@sai.msu.su> 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