Re: Problem creating a database in a script; '"template1"

[Madison Kelly <linux@xxxxxxxxxxx>]

Dennis Jenkins wrote:
> --- Madison Kelly <linux@xxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend