Re: createdb fails

> /var/log/pgsqld.log -o -i
>
>
>
> /usr/local/pgsql/bin/createdb management <-- fails here
>
> /usr/local/pgsql/bin/createdb test <-- fails here
>
>
>
>
>
> Any help on what's causing this behavior and how to fix is appreciated.
>
>
>
> -Allen
>
>
>
>
>
>
>
> +=======================================================================
> ===================+
>
> pgsqld.log:
>
>
>
> 2004-02-02 17:33:00 [1555]   LOG:  database system is ready
>
> 2004-02-02 17:33:01 [1557]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1557]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1557]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1557]   LOG:  duration: 0.035097 sec
>
> 2004-02-02 17:33:01 [1557]   LOG:  query: SELECT d.datname as "Name",
>
>        u.usename as "Owner",
>
>        pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
>
> FROM pg_catalog.pg_database d
>
>   LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
>
> ORDER BY 1;
>
> 2004-02-02 17:33:01 [1557]   LOG:  duration: 0.024846 sec
>
> 2004-02-02 17:33:01 [1596]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1596]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1596]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1596]   LOG:  duration: 0.000521 sec
>
> 2004-02-02 17:33:01 [1596]   LOG:  query: SET autocommit TO 'on';CREATE
> DATABASE "management"
>
> 2004-02-02 17:33:01 [1621]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1621]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1621]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1621]   LOG:  duration: 0.000509 sec
>
> 2004-02-02 17:33:01 [1621]   LOG:  query: SET autocommit TO 'on';CREATE
> USER "management" CREATEDB CREATEUSER
>
> 2004-02-02 17:33:01 [1626]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1626]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1626]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1626]   LOG:  duration: 0.000509 sec
>
> 2004-02-02 17:33:01 [1626]   LOG:  query: SET autocommit TO 'on';CREATE
> DATABASE "test"
>
> 2004-02-02 17:33:01 [1626]   ERROR:  CREATE DATABASE: source database
> "template1" is being accessed by other users
>
> 2004-02-02 17:33:01 [1631]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1631]   LOG:  connection authorized: user=pgsql
> database=management
>
> **************************************************************************************
> This email message and any files transmitted with it contain confidential information intended only for the person(s)
towhom this email message is addressed. If you have received this email message in error, please notify the sender
immediatelyby telephone or email and destroy the original message without making a copy. Thank you. 
> **************************************************************************************
>
>
>