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

From: Madison Kelly <linux(at)alteeve(dot)com>
To: Dennis Jenkins <dennis(dot)jenkins(at)sbcglobal(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem creating a database in a script; '"template1"
Date: 2005-09-09 20:06:14
Message-ID: 4321EB36.6070704@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dennis Jenkins wrote:
>
> --- Madison Kelly <linux(at)alteeve(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stan 2005-09-09 20:40:24 Can't connect to instance with pgaccess
Previous Message Dennis Jenkins 2005-09-09 19:50:37 Re: Problem creating a database in a script; '"template1" is being accessed'