Re: Problem creating a database in a script; '"template1" - Mailing list pgsql-general

Dennis Jenkins wrote:
>
> --- Madison Kelly <linux@alteeve.com> wrote:
>
>
>>Hi all,
>>
>>createdb: database creation failed: ERROR:  source
>>database "template1"
>>is being accessed by other users
>
>
>
> I get that error every time that anyone is connected
> to the database using pgAdmin.  We have to get
> everyone to disconnect before we can create a
> database.
>
> Everyone out of the pool!  Adult swim!
>
>
> Dennis Jenkins


Haha,

   I found a tip from google goups that suggested adding '-T template0'
which seems to have just solved my problem. Maybe it would help you, too?

Madison