> /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) to whom this email message is addressed.
> If you have received this email message in error, please notify the sender
> immediately by telephone or email and destroy the original message without making a
> copy. Thank you.
> **************************************************************************************
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
